SQLite Forum

SQLite Date Format
Login

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

https://sqlite.org/lang_datefunc.html