TIME Data Type | Data Types and Literals | Teradata Vantage - 17.10 - TIME Data Type - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Types and Literals

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

Identifies a field as a TIME value.

This is not the value returned by the TIME function, which is formatted as a REAL number.

ANSI Compliance

TIME is non-ANSI standard. SQL Engine stores a TIME value in UTC.


TIME [ ( fractional_seconds_precision ) ] [ attributes [...] ]

Syntax Elements

A single digit representing the number of significant digits in the fractional portion of the SECOND field.
Values for fractional_seconds_precision range from 0 to 6 inclusive.
The default precision is 6.
Appropriate data type, column storage, or column constraint attributes.
See Core Data Type Attributes and Storage and Constraint Attributes for specific information.