DateTime Fields | Data Types and Literals | Teradata Vantage - 17.10 - DateTime Fields - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1143-171K
Language
English (United States)

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 should 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.