SQLite Date Format

(1) By Luke (BD117DDA) on 2020-10-29 08:49:03

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]

>  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>