Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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>