Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
Functions, 110 of 121
TRUNC
returns d with the time portion of the day truncated to the unit specified by the format model fmt. If you omit fmt, d is truncated to the nearest day. See "ROUND and TRUNC Date Functions" for the permitted format models to use in fmt.
SELECT TRUNC(TO_DATE('27-OCT-92','DD-MON-YY'), 'YEAR') "New Year" FROM DUAL; New Year --------- 01-JAN-92
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|