SYSDATE returns the current date and time of the operating system on which the database resides, taking into account the time zone of the database server’s operating system that was in effect when the database was started.
- This function requires no arguments.
- The data type of the returned value is
- The format returned depends on the value of the
NLS_DATE_FORMAT initialization parameter.
SELECT SYSDATE curr_time FROM DUAL;
- By default
SYSDATE does not display the time. You must use
TO_CHAR conversion function to display the time along with date as per specified format.
SELECT TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS') curr_time