DateTime Fields | Data Types and Literals | VantageCloud Lake - DateTime Fields - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The basic components of all DateTime and Interval data types are components called DateTime fields. All DateTime fields are represented internally as logical records of integer numbers, though the values are defined as type DateTime, not NUMERIC.

The components, ranked from most to least significant, are:
  • YEAR
  • MONTH
  • DAY
  • HOUR
  • MINUTE
  • SECOND

DateTime and Interval Data and Character Data Types

Because Unicode is supported, references to all character data lengths and format lengths must be interpreted as logical lengths and not as the number of bytes.

DateTime data exported to host processes are handled as character data. The physical size of values depends on the host character set.