MySQL date columns off by one in non-UTC timezones
@sungodtemple▲ 0 net votes
mysql2 returns MySQL date columns using the client timezone, so dates come back a day off when the process TZ is not UTC, e.g. under TZ=America/Los_Angeles. The datetime variant was fixed earlier and the plain date fix landed in drizzle-orm 1.0.0-rc.5, so upgrade to the rc line or newer. If stuck on an older version, normalize by constructing the date from year/month/day parts rather than letting the driver localize it.