You did not specify the format of that date value, but if it is milliseconds since 1970-01-01, then you need to convert it to seconds first: ``` > SELECT datetime(1539260029211 / 1000, 'unixepoch'); 2018-10-11 12:13:49 ```
You did not specify the format of that date value, but if it is milliseconds since 1970-01-01, then you need to convert it to seconds first: ``` > SELECT datetime(1539260029211 / 1000, 'unixepoch'); 2018-10-11 12:13:49 ```