Home
Compass SQL Reference
Datetime functions
YEAR
YEAR
Use YEAR to return the year from a date expression.
Syntax
YEAR(date_expression)
Side TOC
Side TOC
Compass SQL Reference
Query structure
Expressions and comparison functions
Logical and comparison operators
String functions
Mathematical operators
Mathematical functions
Aggregation functions
Datetime functions
ADD_MONTHS
CURRENT_DATE
CURRENT_TIMESTAMP
DATEADD
DATEDIFF
DATEPART
DATE_FORMAT
DATE_SUB
DATE_TRUNC
DAY, DAYOFMONTH, DAY_OF_MONTH
FROM_UTC_TIMESTAMP
GETDATE
GETUTCDATE
LAST_DAY
MONTH
TO_DATE
TRUNC
UNIX_TIMESTAMP
YEAR
Conversion functions
Analytic functions
Views