Example: date_time_term With an Integer Numeric Time Zone Specifier

Teradata Database SQL Functions, Operators, Expressions, and Predicates

brand
Software
prodname
Teradata Database
vrm_release
16.10
category
Programming Reference
featnum
B035-1145-161K

In this example, the date_time_primary is a built-in time function and the time zone displacement is specified by the negative integer numeric value for Pacific Standard Time.

SELECT CURRENT_TIME AT TIME ZONE -8;