Help Center/
Data Lake Insight/
SQL Syntax Reference (To Be Offline)/
Spark SQL Syntax Reference (Unavailable Soon)/
Built-in Functions/
Date Functions/
current_date
Updated on 2023-10-25 GMT+08:00
current_date
This function is used to return the current date, in the yyyy-mm-dd format.
Similar function: getdate. The getdate function is used to return the current system time, in the yyyy-mm-dd hh:mi:ss format.
Syntax
current_date()
Parameters
None
Return Values
The return value is of the DATE type, in the yyyy-mm-dd format.
Example Code
The value 2023-08-16 is returned.
select current_date();
Parent topic: Date Functions
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
