Oracle® OLAP Expression Syntax Reference Release 11.2 Part Number E23381-01 |
|
|
PDF · Mobi · ePub |
SYSDATE
returns the current date and time of the operating system on which the database resides. The format of the value depends on the value of the NLS_DATE_FORMAT
initialization parameter.
DATE
SYSDATE
SYSDATE
returns a value such as 13-AUG-06
with NLS_DATE_FORMAT
set to DD-MON-RR
.
TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')
returns a value such as 08-13-2006 17:20:47
. The date format provided in the call to TO_CHAR
displays both the date and the time.