Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

Truncate and round a date that falls into the second part of a year, the results would be different

SQL> SQL> SELECT   2     SYSDATE + 100                fall_date,   3     TRUNC(SYSDATE + 100, 'YEAR') truncated,   4     ROUND(SYSDATE + 100, 'YEAR') rounded   5  FROM DUAL; FALL_DATE TRUNCATED ROUNDED --------- --------- --------- 28-SEP-08 01-JAN-08 01-JAN-09 SQL>