Database Management System

Oracle SQL Interview Questions

Pinterest LinkedIn Tumblr

Write a SQL query to display the current date

The DUAL table is a special one-row, one-column table present by default in Oracle and other database installations. The sysdate returns the current date from the oracle database server.

SELECT sysdate from dual;

Solution

SELECT TO_CHAR(SYSDATE, 'MM-DD-YYYY HH24:MI:SS') "NOW"  FROM DUAL;            
1 2 3 4 5 6 7 8 9 10

Write A Comment