LinuxJedi in Spacetime: Properly Handling Time and Date
MariaDB Corporation's Andrew Hutchings discusses the intricacies of handling time and date, including timezones and leap seconds.
0:00 Start
0:50 1/2/20
1:20 8 o'clock
1:33 1pm
1:47 ISO 8601
2:33 Time and date are difficult!
2:48 Timezones
3:37 Daylight savings time
5:25 How do we resolve these two problems?
5:38 mariadb-tz-info-to-sql
6:16 UTC (Coordinated Universal Time)
7:17 Leap Seconds
9:35 TAI (International Atomic Time)
10:12 Google's leap smear
10:47 MariaDB's SQL_MODE recommendations
11:19 Summary
Links:
Time zones in the MariaDB Knowledge Base:
https://mariadb.com/kb/en/time-zones/
Google leap smear:
https://developers.google.com/time/smear
mariadb-tzinfo-to-sql
https://mariadb.com/kb/en/mysql_tzinf...
___
Music:
"Limit 70" Kevin MacLeod (incompetech.com)
Licensed under Creative Commons: By Attribution 4.0 License
http://creativecommons.org/licenses/b...