mtlynch / whatgotdone

A tool for sharing weekly task updates with teammates.
https://whatgotdone.com
Apache License 2.0
143 stars 14 forks source link

Fix strftime calls in sqlite package #793

Open mtlynch opened 2 years ago

mtlynch commented 2 years ago

The extra 'utc' modifier was incorrect, as it assumes that the previous time is in local time, but 'now' is in UTC:

https://www.sqlite.org/lang_datefunc.html

mtlynch commented 1 year ago

Need to add a SQL migration to fix legacy entries before merging this in.