13th March 2021
TIL
Querying for items stored in UTC that were created on a Thursday in PST
— This came up as [a question](https://news.ycombinator.com/item?id=26443148) on Hacker News. How can you query a SQLite database for items that were created on a Thursday in PST, when the data is stored in UTC?
Recent articles
- Some thoughts on the Navier–Stokes Millennium Prize Problem - 8th September 2026
- The Pelican comparison grid for Astra is pretty interesting - 4th September 2026
- OpenAI's rogue agents were caught communicating via public wikis - 4th September 2026