Date Conversion


I need to convert to human format the “offlineDate” field on the “ofPresence” table. ¿What Can I do?

Thank you very much!!!


It appears to be stored as the number of milliseconds since Jan 1, 1970 (the epoch for Java time).

Which database are you using? Here’s the postgres variant

(timestamp ‘epoch’ + int8(“logtime”) / 1000 * interval ‘1 second’)