Buy Percona ServicesBuy Now!

Things you didn’t know about MySQL and Date and Time and DST

 | April 6, 2021 |  Posted In: MySQL, Open Source Databases, Tools

(based on a conversation with a colleague, and a bit of Twitter) A Conundrum A developer colleague paged me with this:

It is obviously wrong, and weirdly so. It only works for “2 year”, not with other values:

It has to be exactly 730 days (2 * 365 days, 2 years):

The […]

Read More