TIME Function Syntax | Teradata Vantage - TIME Function Syntax - Analytics Database - Teradata Vantage

SQL Functions, Expressions, and Predicates

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-01-12
dita:mapPath
obm1628111499646.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
kby1472250656485
lifecycle
latest
Product Category
Teradata Vantageā„¢
TIME [ AT { LOCAL | [ TIME ZONE ] { expression | time_zone_string } } ]

Syntax Elements

LOCAL
The value returned is constructed from the session time and session time zone if the DBS Control flag TimeDateWZControl is enabled.
If TimeDateWZControl is disabled, the value returned is constructed from the time value local to Vantage and the session time zone.
TIME ZONE
Use the time zone displacement defined by expression.
expression
The data type of expression should be INTERVAL HOUR(2) TO MINUTE or it must be a data type that can be implicitly converted to INTERVAL HOUR(2) TO MINUTE.
time_zone_string
time_zone_string determines the time zone displacement.