17.10 - Example - Advanced SQL Engine - Teradata Database

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

CREATE TABLE TimeInfo
  (Id INTEGER
  ,Offset INTERVAL SECOND (2,3));
   
INSERT TimeInfo (1001, INTERVAL -'15.244' SECOND);