Help Center/ Data Lake Insight/ SQL Syntax Reference (Kuala Lumpur Region)/ Spark SQL Syntax Reference/ Built-in Functions/ Date Functions/ getdate
Updated on 2025-01-22 GMT+08:00
View PDF
Share

getdate

This function is used to return the current system time, in the yyyy-mm-dd hh:mi:ss format.

Similar function: current_date. The current_date function is used to return the current date, in the yyyy-mm-dd format.

Syntax

getdate()

Parameters

None

Return Values

The return value is of the STRING type, in the yyyy-mm-dd hh:mi:ss format.

Example Code

If the current time is 2023-08-10 10:54:00, 2023-08-10 10:54:00 is returned.

select getdate();
Parent topic: Date Functions