simonw / til

Today I Learned
https://til.simonwillison.net
Apache License 2.0
1.02k stars 81 forks source link

SQLite timestamps with floating point seconds #90

Open Moaneschien opened 3 months ago

Moaneschien commented 3 months ago

as this seems the only way to respond:

select strftime('%FT%R:%f'); gives 2024-03-14T06:22:01.416

or whith 'subsec' unix time stamps in the table

with t(ue) as (select('subsec'))
select strftime('%FT%R:%f',  (select ue from t))

Cheers.