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

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)

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.

Syntax

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

Syntax Elements

fractional_seconds_precision
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.
attributes
Appropriate data type, column storage, or column constraint attributes.
See Core Data Type Attributes and Storage and Constraint Attributes for specific information.