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)