Orca - how are dates encoded in the database?

Hi All

Does anyone know how the date of a forum post is encoded in the database. I am looking at the "when" field in a bx_forum_post. record It contains a value like "1344843582".

Thank you so much!

Looks like a UNIX time stamp to me.

those are timestamp. seconds from 1 Jan 1970. Used to calculate the time.

The real question: Is there an easy way to convert it to human-readable?

Figured something like Excel might have been capable, but it didn't turn out right last time I tried it. 

That is done with the PHP date function. Most php date and time functions use a unix time stamp which is why i use them in pretty much all the work i do as well.

http://php.net/manual/en/function.date.php

Or if your want to convert a single number just to see what it is, your can do it online here.

http://www.onlineconversion.com/unix_time.htm

That may not be accurate depending on time zone settings between the servers which affect the result based on time zone.

Thank you hugely, Deano! The manual conversion tool you have provided is solving my problem. I really appreciate your fast response.

Blue skies!