17.10 - Example - Advanced SQL Engine - Teradata Database

The following statement creates a table with an INTERVAL HOUR TO MINUTE column:

CREATE TABLE TimeInfo
  (Id INTEGER
  ,Offset INTERVAL HOUR (4) TO MINUTE);