curdate function

Returns the current date at the start of query evaluation.

Applies to: check marked yes Databricks SQL preview check marked yes Databricks Runtime 11.3 and above

Syntax 

curdate()

Arguments

This function takes no arguments.

Returns

A DATE.

This function is a synonym for current_date.

Examples 

> SELECT current_date();
 2020-04-25

> SELECT current_date;
 2020-04-25