Example: Creating a Table with INTERVAL SECOND Data Type - Teradata VantageCloud Lake

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);