17.10 - Example - Advanced SQL Engine - Teradata Database

The following statement creates a table with an INTERVAL YEAR TO MONTH column:

CREATE TABLE TimeInfo
  (Id INTEGER
  ,Offset INTERVAL YEAR (4) TO MONTH);