YEAR() — Returns the year as an integer value.
YEAR( timestamp-or-date )
The YEAR() function returns an integer value representing the year of a DATE or TIMESTAMP value. The YEAR() function produces the same result as using the YEAR keyword with the EXTRACT() function.
The following example uses the DAY(), MONTH(), and YEAR() functions to return a timestamp column as a formatted date string.
SELECT CAST( MONTH(starttime) AS VARCHAR) || '/' || CAST( DAY(starttime) AS VARCHAR) || '/' || CAST( YEAR(starttime) AS VARCHAR), title, description FROM event ORDER BY starttime;