Skip to main content
3 of 3
added 17 characters in body
Evan Carroll
  • 64.7k
  • 49
  • 251
  • 496

What is the CURRENT_DATE or current date value function for SQL Server?

What is the SQL Server functionality that allows you to get the current date as a DATE type like the SQL Standard's CURRENT_DATE feature. What is the <current date value function> for SQL Server?

Using PostgreSQL, I'm looking for something like,

SELECT CURRENT_DATE;
 current_date 
--------------
 2018-06-27
(1 row)
Evan Carroll
  • 64.7k
  • 49
  • 251
  • 496