TIME Data Type | Data Types and Literals | Teradata Vantage - TIME Data Type - Teradata Vantage - Analytics Database

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. Analytics Database 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.