17.10 - Example - Advanced SQL Engine - Teradata Database

The following statement creates a table with an INTERVAL DAY TO SECOND column:

CREATE TABLE TimeInfo
  (Id INTEGER
  ,Offset INTERVAL DAY (4) TO SECOND (4));