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)