I’m trying to make a small php script using the mysql db to print the logs of the chatrooms. I would like to show the date when each message has been sent but I don’t know how to find it. For exemple 001202745533058 should be tuesday 11 february 2008, 17:02:52, but I don’t understand how it is encoded.
What you see in the database is a string representation of the java long date value (I call it a ticks value times 1000). Here is the sql I use in Postgresql to convert it to a datetime object.