Ispirer Website Ispirer Capabilities - MySQL Migration Free Trial

MySQL Data Types - TIMESTAMP

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

Data Types
Datetime DATE TIME DATETIME YEAR

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.