Tiny SQLite TIL today: til.simonwillison.net/sqlite/f
```
select strftime('%Y-%m-%dT%H:%M:%f')
```
Returns 2024-03-14T04:23:25.087Z - a timestamp with seconds in milliseconds, useful for storing as a readable string that can then be sorted alphabetically

Follow

@simon I think you dropped a Z from the format string (or, equivalently, included an extra one in the output).

Sign in to participate in the conversation
Qoto Mastodon

QOTO: Question Others to Teach Ourselves
An inclusive, Academic Freedom, instance
All cultures welcome.
Hate speech and harassment strictly forbidden.