< Why Is Portability Important?   (Previous) Table of Contents (Next)   TIMESTAMP: Setting Column Type >

TIMESTAMP: Column Types

Database Data Type Bytes Notes
Access 2000 DATETIME 8
DB2 8.1 TIMESTAMP 10
Firebird 1.5 TIMESTAMP 8
FrontBase 4.1 TIMESTAMP 8
MySQL 4.0 – 4.1 DATETIME 8 TIMESTAMP usable in >= 4.1
Oracle 9.2 DATE 7 TIMESTAMP(0) available >= 9
PostgreSQL 7.4 TIMESTAMP(0) 8
SQL Server 2000 DATETIME 8
SQLite 2.8 TIMESTAMP ~19
Sybase ASE 12.5 DATETIME 8