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
View PDF
Share

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