Constant Functions

CURRENT_DATE()

Returns the current date at the start of a query.

> select current_date();
2023-01-25

CURRENT_TIMESTAMP()

Returns the current date & time at the start of a query, in the yyyy-mm-dd hh:mm:ss timestamp format.

> select current_timestamp;
2023-01-25 08:08:00

NOW()

Alias of current_timestamp()

Last updated

#930: Cross account hive GCP

Change request updated