Ispirer Website
Ispirer Capabilities - MySQL Migration
Free Trial
Versions: MySQL 5.x, 4.x and 3.23
MySQL - TIMESTAMP | |
---|---|
Syntax | TIMESTAMP |
Data | Auto-updated date and time data (day, month, year, hours, minutes and seconds) The first TIMESTAMP column is set to the date and time of the most recent UPDATE or INSERT operation if you do not assign a value or specify NULL |
Range | January 01, 1970 00:00:01 to January 09, 2038 23:59:59 |
Special Values | MySQL TIMESTAMP accepts zero timestamp value '0000-00-00 00:00:00' (or 0, '0') and 0 for day and month (can be disabled by SQL Mode NO_ZERO_IN_DATE. Note: MySQL ODBC returns zero date as NULL |
Error Handling | if SQL Mode ALLOW_INVALID_DATES is specified, MySQL checks only month in the range 0-12 and day in the range 0-31 and invalid day can be inserted (Nov 31 i.e.) |
Internals | TIMESTAMP is stored as the number of seconds since '1970-01-01 00:00:00' |
Storage Size | 4 bytes |
Standards | MySQL Extension |
Related Data Types in MySQL
All Data Types