1d13e5d2_Bristle_Software_SQL_Tips__Description
[Oracle] TO_CHAR(date, format_string) Examples: TO_CHAR(SYSDATE, 'yyyy') TO_CHAR(SYSDATE, 'ss') etc. Also, as of Oracle 9.2: EXTRACT (date_part FROM date) Examples: EXTRACT(YEAR FROM SYSDATE) EXTRACT(SECOND FROM SYSDATE) etc. [MS SQL Server] DATEPART(date_part, date) Examples: DATEPART(YEAR, GETDATE()) DATEPART(SECOND, GETDATE()) etc. Also: YEAR(), DAY(), MONTH() [Description] 
Parse date into parts (year, month, day, hour, min, sec, etc.)
Bristle Software SQL Tips
Description