til icon indicating copy to clipboard operation
til copied to clipboard

SQLite timestamps with floating point seconds

Open Moaneschien opened this issue 1 year ago • 0 comments

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.

Moaneschien avatar Mar 14 '24 06:03 Moaneschien