Name
DATETIME
Syntax
DATETIME
Format
YYYY-MM-DD hh:mm:ss (2001-01-01 01:00:00)
Storage
8 bytes
Description
Stores a specific time in the range of 12:00:00 AM, January 1, 1000
('1000-01-01 00:00:00'
) to 11:59:59 P.M., December
31, 9999 ('9999-12-31 23:59:59'
) in the Gregorian
calendar.
Get Managing & Using MySQL, 2nd Edition now with O’Reilly online learning.
O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.