How to find out current date of the database in Oracle

SELECT SYSDATE FROM DUAL;

Above query will return only date. if you want to fetch date with time then you can use below query:-

SELECT SYSTIMESTAMP CURRENT_DATE FROM DUAL;




Read Also:-  Find out current date in SQL