Hello,
I’ve opened the Openfire embedded-db-viewer.sh and am doing a SELECT * FROM PUBLIC.OFMUCCONVERSATIONLOG. How can I change the SELECT statement so that it converts the logtime column (displayed in epoch) to a human readable form?
Abylin
Hello,
I’ve opened the Openfire embedded-db-viewer.sh and am doing a SELECT * FROM PUBLIC.OFMUCCONVERSATIONLOG. How can I change the SELECT statement so that it converts the logtime column (displayed in epoch) to a human readable form?
Abylin