17.10 - Example - Advanced SQL Engine - Teradata Database

The following CREATE TABLE statement defines a PERIOD(TIME(6)) 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));