The following statement creates a table with an INTERVAL MINUTE TO SECOND column:
CREATE TABLE TimeInfo (Id INTEGER ,Offset INTERVAL MINUTE (1) TO SECOND (2)); INSERT TimeInfo (1001, INTERVAL '6:15.24' MINUTE TO SECOND);
The following statement creates a table with an INTERVAL MINUTE TO SECOND column:
CREATE TABLE TimeInfo (Id INTEGER ,Offset INTERVAL MINUTE (1) TO SECOND (2)); INSERT TimeInfo (1001, INTERVAL '6:15.24' MINUTE TO SECOND);