Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - SQL Usage » SQL dialects and compatibility » Transact-SQL-compatible databases


The special Transact-SQL TIMESTAMP column and data type

SQL Anywhere supports the Transact-SQL special TIMESTAMP column. The TIMESTAMP column, together with the TSEQUAL system function, checks whether a row has been updated.

Two meanings of timestamp

SQL Anywhere has a TIMESTAMP data type, which holds accurate date and time information. It is distinct from the special Transact-SQL TIMESTAMP column and data type.

 Creating a Transact-SQL TIMESTAMP column in SQL Anywhere
 The data type of a TIMESTAMP column
 Using TSEQUAL for updates