First apologies if this is off topic/website.

Exporting a table from a "mySQL" database into Excel in one of the fields I have the interger 1313046000 which I know translates into Thursday, 11th August 2011 08:00hrs.

I done some internet searching & believe the interger is a "strftime" number but I can't find a way to translate it.

Is there some easy way, in Excel, to tranlate the interger into meaningful data.

Please note I am only capable of exporting the table and so can't do anything to it before export.

Thanks in advance

I hope you get help on this...not my area though, sorry.

I take it that you are familiar with this: http://www.docs.hp.com/en/B2355-90695/strftime.3C.html

Thanks for that reference, I've been there already.

It's a SQL function & gobbleygook to me.

If the interger was in seconds from a start point (say 1/1/1800 AD) I could work it out, but it isn't.

Excel translation must be out there somewhere

For those interested it turns out that in MySQL the number

1313046000

is in fact the number of seconds since 1/1/1970.

Excel uses 1/1/1900

All is now well

Good to know - thanks for posting the solution.