TIMESTAMP indicates when each row in the table was last modified.
TIMESTAMP
When a column is declared with DEFAULT TIMESTAMP, a default value is provided for insert and load operations. The value is updated with the current date and time whenever the row is updated.
On INSERT and LOAD, DEFAULT TIMESTAMP has the same effect as CURRENT TIMESTAMP. On UPDATE, if a column with a default value of TIMESTAMP is not explicitly modified, the value of the column is changed to the current date and time.
Sybase IQ does not support DEFAULT values
of UTC TIMESTAMP or CURRENT UTC TIMESTAMP,
nor does IQ support the database option DEFAULT_TIMESTAMP_INCREMENT.
Sybase IQ generates an error every time an attempt is made to insert
or update the DEFAULT value of a column of type UTC
TIMESTAMP or CURRENT UTC TIMESTAMP.
