Working with SQL timestamp fields requires that values be referenced in a specific format. As a result, if using INSERT statements, provide the timestamp value in a particular edited format, and this value is constant regardless of whether ISO, USA, EUR, or JIS string format are being used for other fields.
Release: All supported releases.
Component: SQL.
To use an INSERT statement for a timestamp value, please follow the format as noted in the Datacom/DB SQL User Guide. This value contains the year, month, day, hour, minute, second, and microseconds. For example, to insert a row with the timestamp of 29 January 2016, at 1:34.26.184232 pm, use:
INSERT INTO tblname
VALUES ( ... ,'2016-01-29-13.34.26.184232', ... );
Likewise, when retrieving a timestamp value from a table, even though the column is stored in Datacom/DB as a 10-byte binary field, it is returned in the same character form as above.