Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Saturday 6 September 2014

How to find out current date of the database in SQL

SELECT CURDATE() CURRENT_DATE;

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

SELECT NOW() CURRENT_DATE;




Read Also:-  Find out Current date in Oracle

No comments:

Post a Comment

Please provide your feedback in the comments section above. Please don't forget to follow.