powered by Jive Software

How is jivepresence.offlinepresenceDate formatted

What is the date time format of the offlinepresencedate field in jivepresence table?

How can I reuse it, it has bigger value that Unix date time format…

Thank you by advance


you may want to download the source code and take a look at it, but I think that one should use a plugin and the Openfire API to access the database and never access it directly as this can cause random problems, especially if the database schema changes.


It’'s milliseconds since the epoch. So just divide it by 1000 and use it like a unix timestamp.