sqlite

Unix timestamp in milliseconds in SQLite

I wanted to retrieve the time in milliseconds since the Unix epoch in SQLite. Fetching seconds since the epoch is easy: Prior to SQLite 3.42.0 (released in May 2023) milliseconds were much more…