Example: Creating a Table with INTERVAL DAY TO MINUTE Data Type - Teradata Vantage

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

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