Podcast: Play in new window | Download (16.3MB)
Subscribe: RSS
This week we talk about time formats and time zones in MySQL – including how changing the system time changes TIMESTAMP values but not DATETIME values. We also talk about how to handle and store microseconds in MySQL.
From the MySQL manual:
date and time types
TIMESTAMP properties and how it is stored in UTC transparently in the database
ALLOW_INVALID_DATES sql_mode