Trunc sql

This article is tagged with: Trunc sql and mysql

trunc sql

SELECT TRUNC(TO_DATE('27-OCT-92','DD-MON-YY'), 'YEAR')
"New Year" FROM DUAL;

New Year
---------
01-JAN-92

This article is tagged with: Trunc sql and mysql