Use TRUNC(date_variable) when you want to extract a date from a timestamp

    

SQL>
SQL> DECLARE
  2    d DATE := SYSDATE;
  3  BEGIN
  4    dbms_output.put_line(TO_CHAR(TRUNC(d),'DD-MON-YY HH24:MI:SS'));
  5  END;
  6  /
26-OCT-09 00:00:00

PL/SQL procedure successfully completed.

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.	truncate and round a date that falls into the second part of a year, the results would be different:
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

Use TRUNC(date_variable) when you want to extract a date from a timestamp : TRUNC Date « Date Timezone « Oracle PL / SQL

Related examples in the same category