16.20.16.20 - 16.20 - Compatible Types - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

The following table describes the allowed combinations of source and target types when both the source and the target types are Period data types.

Source Type Target Type
PERIOD(DATE) PERIOD(DATE)
PERIOD(TIMESTAMP[(m)] [WITH TIME ZONE])
PERIOD(TIME[(n)] [WITH TIME ZONE]) PERIOD(TIME[(m)] [WITH TIME ZONE])

where m is the target precision, m must be greater than or equal to the source precision n. The default for m is 6.

PERIOD(TIMESTAMP[(m )] [WITH TIME ZONE])

where m is the target precision, m must be greater than or equal to the source precision n. The default for m is 6.

PERIOD(TIMESTAMP[(n)] WITH TIME ZONE) PERIOD(DATE)
PERIOD(TIME[(m)] [WITH TIME ZONE])

where m is the target precision, m must be greater than or equal to the source precision n. The default for m is 6.

PERIOD(TIMESTAMP[(m)] [WITH TIME ZONE])

where m is the target precision, m must be greater than or equal to the source precision n. The default for m is 6.