curdate function
Applies to: 
Databricks SQL preview Databricks Runtime 11.3 LTS and above
Returns the current date at the start of query evaluation. This function is a synonym for current_date.
Syntax
curdate()
Arguments
This function takes no arguments.
Returns
A DATE.
Examples
SQL
> SELECT current_date();
2020-04-25
> SELECT current_date;
2020-04-25