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.