Constant | Meaning |
NULL | Indicates a missing or unknown value in a table. |
CURRENT_DATE | Current date (as ANSI date type) |
CURRENT_TIME | Current time with time zone |
CURRENT_TIMESTAMP | Current date and time with time zone |
CURRENT_USER | Same as user |
INITIAL_USER | Vector user identifier in effect at the start of the session |
LOCAL_TIME | Current time without time zone |
LOCAL_TIMESTAMP | Current timestamp without time zone |
SESSION_USER | Same as user |
SYSDATE | Current date and time set for the operating system on which the database resides. The format returned depends on the default TIMESTAMP format. In distributed SQL statements, this function returns the date and time set for the operating system of your local database. When not used inside a TO_CHAR() wrapper function, SYSDATE always returns a date in the default date format. Examples: SELECT SYSDATE\g 2013-08-06 22:28:35.784654-07:00 SELECT TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS')\g 08-06-2013 22:29:58 |
SYSTEM_USER | Operating system user identifier of the user who started the session |
USER | Effective user of the session (the Vector user identifier, not the operating system user identifier) |