SQLite Date Format
(1) By Luke (BD117DDA) on 2020-10-29 08:49:03 [source]
Hi
Total novice here, I've used an SQLite reader to read my "web data" file from Chrome. The "Date_Created" field doesn't display a date but a long number: 1603562938.
I need to know what this is, can anyone help?
Cheers
(2) By Stephan Beal (stephan) on 2020-10-29 09:33:07 in reply to 1 [link] [source]
The "Date_Created" field doesn't display a date but a long number: 1603562938.
That's a Unix Epoch timestamp. From a Linux console:
$ date --date='@1603562938'
Sat 24 Oct 2020 08:08:58 PM CEST
You'll want to look at:
https://www.sqlite.org/datatype3.html
and