In this example, the date_time_term is a date_time_primary column value named f1.
TS.f1 is a value of type TIME or TIMESTAMP and the time zone displacement is based on the time zone string 'America Pacific'.
SELECT f1 AT TIME ZONE 'America Pacific' FROM TS;