Sybase ASE Data Types - TIMESTAMP

Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x

Sybase ASE - TIMESTAMP
Syntax	TIMESTAMP
Data	Binary data that is automatically updated each time the row is modified
Notes	A table can have only one TIMESTAMP column
Internals	Implemented as BINARY(8)
Storage Size	8 bytes
Standards	Sybase Transact-SQL Extension

Sybase ASE TIMESTAMP - Equivalents in Other Databases

Database	Data Type and Conversion
SQL Server	TIMESTAMP and ROWVERSION, automatically generated binary data

All Data Types

Oracle

SQL Server

IBM DB2

MySQL

PostgreSQL

Sybase ASE

Sybase ASA

Informix DS

Teradata

HP Neoview

Interbase/Firebird