How do you find current date and time in Oracle?

Oracle - Interview Questions

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;

More Technologies Interview Questions

Machine Learning

Artificial Intelligence

Ethical Hacking

HyperAutomation

Microsoft Azure

Cloud Computing

Quantum Computing

Cognitive Computing

Neural Networks

Virtual Reality

Augmented Reality

Full Stack Developer

Advertisement