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 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.