Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-01 |
|
|
View PDF |
Syntax
trunc_date::=
Purpose
The TRUNC
(date) function returns date
with the time portion of the day truncated to the unit specified by the format model fmt
. The value returned is always of datatype DATE
, even if you specify a different datetime datatype for date
. If you omit fmt
, then date
is truncated to the nearest day. Please refer to "ROUND and TRUNC Date Functions" for the permitted format models to use in fmt
.
Examples
The following example truncates a date:
SELECT TRUNC(TO_DATE('27-OCT-92','DD-MON-YY'), 'YEAR') "New Year" FROM DUAL; New Year --------- 01-JAN-92