Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
Functions, 120 of 121
Table 4-2 lists the format models you can use with the ROUND
and TRUNC
date functions and the units to which they round and truncate dates. The default model, 'DD', returns the date rounded or truncated to the day with a time of midnight.
The starting day of the week used by the format models DAY, DY, and D is specified implicitly by the initialization parameter NLS_TERRITORY
.
See Also:
Oracle8i Reference and Oracle8i National Language Support Guide for information on this parameter. |
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|