sysdate

Returns the current date and time in DateTime format, use the To_Char function to display this as a character string:

SQL> select to_char(sysdate,'HH24:MI:SS') "Time Now" from dual;

SQL> select to_char(sysdate,'YYYY MM DD') "Date" from dual;



Related

TO_CHAR - Convert to character string
TO_DATE
- Convert to date value
Date format strings
Oracle SQL Functions


© Copyright SS64.com 1999-2013
Some rights reserved