Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. Truncates May 25, 2005, to the first day in the month
SQL>
SQL> SELECT TRUNC(TO_DATE('25-MAY-2005'), 'MM') FROM dual;
TRUNC(TO_
---------
01-MAY-05
SQL>