Ispirer Website
Ispirer Capabilities - Sybase Migration
Free Trial
Sybase ASE Data Types - SMALLDATETIME
Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x
| Sybase ASE - SMALLDATETIME | |
|---|---|
| Syntax | SMALLDATETIME |
| Data | Date and time data (year, month, day, hours and minutes) |
| Range | January 01, 1900 00:00 to June 06, 2079 23:59 |
| Storage Size | 4 bytes |
| Standards | Sybase Transact-SQL Extension |
Sybase ASE SMALLDATETIME - Equivalents in Other Databases
| Database | Data Type and Conversion |
|---|---|
| Oracle | TIMESTAMP(p), January 1, 4712 BC 00:00:00.000000000 to December 31, 9999 23:59:59.999999999 (nanoseconds accuracy) |
| SQL Server | SMALLDATETIME, January 01, 1900 00:00 to June 06, 2079 11:59 (minute accuracy) |
| MySQL | DATETIME, January 01, 1000 00:00:00 to December 31, 9999 23:59:59 (seconds accuracy) |
| PostgreSQL | TIMESTAMP(p), January 01, 4713 BC 00:00:00:000000 and December 31, 5874897 23:59:59:999999 (microseconds accuracy) |
| Informix | DATETIME YEAR TO MINUTE, January 01, 0001 00:00:00.00000 to December 31, 9999 23:59:59.99999 (with 10 microseconds accuracy) |
| Teradata | TIMESTAMP(p), January 01, 0001 00:00:00.000 to December 31, 9999 23:59:61.999999 (microseconds accuracy) |
| HP Neoview | TIMESTAMP(p), January 01, 0001 00:00:00.000000 to December 31, 9999 23:59:59.999999 (microseconds accuracy) |
| Ingres | TIMESTAMP(p), 0001-01-01 00:00:00 to 9999-12-31 24:00:00 |
Related Data Types in Sybase ASE
All Data Types