Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. TRUNC()
SQL>
SQL> SELECT TRUNC(TO_DATE('25-MAY-2005'), 'YYYY') FROM dual;
TRUNC(TO_
---------
01-JAN-05
SQL>
SQL>
SQL>