AT TIME ZONE

The date function is used to convert a date or date time value to a given time zone.

Syntax

<TIMESTAMP expression> AT TIME ZONE <TIME ZONE>

Example

select CURRENT_TIMESTAMP at time zone ‘est’

The above query returns the current time according to the Eastern time zone.