Name
TIMESTAMP
Syntax
TIMESTAMP[(display_size)]
Format
YYYYMMDDhhmmss (20010101060000)
Storage
4 bytes
Description
A simple representation of a point in time down to the second in the
range of midnight on January 1, 1970, to one minute before midnight
on December 31, 2037. Its primary utility is keeping track of table
modifications. When you insert a NULL
value into a
TIMESTAMP
column, the current date and time are
inserted instead. When you modify any value in a row with a
TIMESTAMP
column, the first
TIMESTAMP
column will be automatically updated
with the current date and time.
Get Managing & Using MySQL, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.