Example: PERIOD(TIME WITH TIME ZONE) Data Type - Teradata Vantage

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