What is the SQL Server functionality that allows you to get the current date like the SQL Standard's CURRENT_DATE feature,

130 F051-06 CURRENT_DATE

• Subclause 6.32, <datetime value function>: The <current date value function>

• Subclause 6.31, <datetime value expression>: When the value is a <current date value function>

What is the <current date value function> for SQL Server?

In PostgreSQL terms, I'm looking for something like,

SELECT CURRENT_DATE;
 current_date 
--------------
 2018-06-27
(1 row)