How do you find current date and time in Oracle? | Eklavya Online

How do you find current date and time in Oracle?

The SYSDATE() function is used in Oracle to find the current date and time of operating system on which the database is running.

SELECT TO_CHAR (SYSDATE, ‘MM-DD-YYYY HH24:MI:SS’) “Current_Date” FROM DUAL;