Skip to main content

TODAY

Description

The TODAY function returns the current date in the specified timezone.

The time zone can be specified with a time zone id, like UTC, GMT+01 or Europe/Berlin. If no time zone is specified UTC is used.

Syntax

TODAY( [time_zone_id] ) 

The <time_zone_id> parameter identifies the time zone as described here.

Example

[1]

Get the current date in UTC:

Query

Column1

TODAY ( )

Input

Output

Result

Column1

Tue Aug 19 2025 00:00:00.000

[2]

Get the current date in the Australia/Sydney timezone:

Query

Column1

TODAY ( 'Australia/Sydney' )

Input

Output

Result

Column1

Tue Aug 19 2025 00:00:00.000