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 |