One use case that happens often in SQL is the need to retrieve today’s date. This could be you are doing an analysis based on recent data, or it could be you are building a script that needs to retrieve the date dynamically. <\/p>\n\n\n\n
Unfortunately there is no standard SQL that allows you to retrieve today’s date across different database systems. So in this post we have gathered the SQL statement needed to retrieve today’s date for the most popular database systems:<\/p>\n\n\n\n
Oracle<\/u><\/p>\n\n\n\n
SQL Server<\/u><\/p>\n\n\n\n MySQL<\/u><\/p>\n\n\n\n DB2<\/u><\/p>\n\n\n\n Hive<\/u><\/p>\n\n\n\n SparkSQL<\/u><\/p>\n\n\n\n BigQuery<\/u><\/p>\n\n\n\n PostgreSQL<\/u><\/p>\n\n\n\n SQLite<\/u><\/p>\n\n\n\n One use case that happens often in SQL is the need to retrieve today’s date. This could be you are doing an analysis based on recent data, or it could be you are building a script that needs to retrieve the date dynamically. Unfortunately there is no standard SQL that allows you to retrieve today’s […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[247],"tags":[],"_links":{"self":[{"href":"https:\/\/www.1keydata.com\/blog\/wp-json\/wp\/v2\/posts\/1333"}],"collection":[{"href":"https:\/\/www.1keydata.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.1keydata.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.1keydata.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.1keydata.com\/blog\/wp-json\/wp\/v2\/comments?post=1333"}],"version-history":[{"count":5,"href":"https:\/\/www.1keydata.com\/blog\/wp-json\/wp\/v2\/posts\/1333\/revisions"}],"predecessor-version":[{"id":1348,"href":"https:\/\/www.1keydata.com\/blog\/wp-json\/wp\/v2\/posts\/1333\/revisions\/1348"}],"wp:attachment":[{"href":"https:\/\/www.1keydata.com\/blog\/wp-json\/wp\/v2\/media?parent=1333"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.1keydata.com\/blog\/wp-json\/wp\/v2\/categories?post=1333"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.1keydata.com\/blog\/wp-json\/wp\/v2\/tags?post=1333"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}SELECT SYSDATE FROM DUAL;<\/code><\/p>\n\n\n\nSELECT GETDATE();<\/code><\/p>\n\n\n\nSELECT CURDATE();<\/code><\/p>\n\n\n\nSELECT current date FROM sysibm.sysdummy1;<\/code><\/p>\n\n\n\nSELECT CURRENT_DATE;<\/code><\/p>\n\n\n\nSELECT CURRENT_DATE or SELECT CURRENT_DATE();<\/code><\/p>\n\n\n\nSELECT CURRENT_DATE;<\/code><\/p>\n\n\n\nSELECT CURRENT_DATE;<\/code><\/p>\n\n\n\nSELECT DATE();<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"