We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
I want more accurate timestamps, but I still want them to fit in an integer field.
The text was updated successfully, but these errors were encountered:
Figured out the recipe for that here: #1 (comment)
It's a bit weird!
cast((julianday('now') - 2440587.5) * 86400.0 * 1000 as integer)
Sorry, something went wrong.
1ecfe51
No need for the .0 on 86400, refs #6
7482768
Unix timestamp in milliseconds in SQLite
ab51e18
Refs simonw/sqlite-history#6
Got a TIL out of this: https://til.simonwillison.net/sqlite/unix-timestamp-milliseconds-sqlite
Release 0.1
c887312
Refs #2, #3, #5, #6
No branches or pull requests
I want more accurate timestamps, but I still want them to fit in an integer field.
The text was updated successfully, but these errors were encountered: