powered by Jive Software

Date Conversion

Hello!!!

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

Thank you very much!!!

UP

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