Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 129 of 177
sysdate::=
SYSDATE
returns the current date and time. The datatype of the returned value is DATE
. The function requires no arguments. In distributed SQL statements, this function returns the date and time on your local database. You cannot use this function in the condition of a CHECK
constraint.
The following example returns the current date and time:
SELECT TO_CHAR (SYSDATE, 'MM-DD-YYYY HH24:MI:SS')"NOW" FROM DUAL; NOW ------------------- 04-13-2001 09:45:51
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|