sqlite - SQLite3 on windows: Convert epoch to normal time -

i trying convert following timestamp(in milliseconds since epoch) normal date-time. using sqlite3 on windows xp.

i using query: select datetime((timestamp/86400000)+25569) table;

(timestamp column name contains values 1289325613669,1289325823860, 1289327180545).

i dont seem getting right values. doing wrong?

do this:

select datetime('1289325613', 'unixepoch');

the unixepoch modifier expects value in seconds.

currently, provide datetime interpreted julian day number.

the reference date , time functions here

shell