17.10 - Example - 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 following CREATE TABLE statement defines a PERIOD(TIME(6) WITH TIME ZONE) column since the precision defaults to 6.

CREATE TABLE t8
(
      job_id        INTEGER,
      job_desc      CHARACTER(15),
      job_status    CHARACTER(1),
      job_hours     PERIOD(TIME WITH TIME ZONE));