SQLite Forum

SQLite Date Format
Login
>  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>