truncate and round a date that falls into the second part of a year, the results would be different: : TRUNC Date « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. TRUNC Date

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>








Related examples in the same category

1.formats used with the TRUNC() function for the DATE data type
2.Trunc a date
3.Truncates 7:45:26 P.M. on May 25, 2005, to the hour
4.TRUNC(SYSDATE,'Q'): Truncating to the quarter
5.TRUNC: Removing the time from SYSDATE
6.Use TRUNC(Date value) in where clause
7.Use TRUNC(date_variable) when you want to extract a date from a timestamp
8.Truncates May 25, 2005, to the first day in the month
9.TRUNC(): truncate May 25, 2005, to the first day in the year