Truncates 7:45:26 P.M. on May 25, 2005, to the hour : TRUNC Date « Date Timezone « Oracle PL / SQL






Truncates 7:45:26 P.M. on May 25, 2005, to the hour

  


SQL>
SQL> --Truncates 7:45:26 P.M. on May 25, 2005, to the hour
SQL>
SQL> SELECT TO_CHAR(TRUNC(TO_DATE('25-MAY-2005 19:45:26','DD-MON-YYYY HH24:MI:SS'), 'HH24'), 'DD-MON-YYYY HH24:MI:SS') FROM dual;

TO_CHAR(TRUNC(TO_DAT
--------------------
25-MAY-2005 19:00:00

SQL>
           
         
    
  








Related examples in the same category

1.formats used with the TRUNC() function for the DATE data type
2.Trunc a date
3.TRUNC(SYSDATE,'Q'): Truncating to the quarter
4.TRUNC: Removing the time from SYSDATE
5.Use TRUNC(Date value) in where clause
6.truncate and round a date that falls into the second part of a year, the results would be different:
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