Oracle® Database SQL Language Reference 11g Release 1 (11.1) Part Number B28286-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. 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