Unix Date Format

UNIX for Beginners Q & A UNIX for Dummies Questions & Answers
1

I have an Foxbase application that saves dates in a character field using a Unix date format.

Does anyone know what the formula is to convert back to a standard date, something that can be, I hesitate to say, understood in a Windows environment, such as Excel or Access.

cheers
peter

2

The only thing I can think that could be would be the Unix Epoch... If it's just a really big number, it's possible that it's (I think) the number of seconds since January 1, 1970. I'ts well over a billion now...

I don't know of any way to convert it easily, short of writing a program or perl script... maybe someone else does?

3

Surely if you ae importing in to Access or Excel then you can write a formula/ macro in either one of these to correctly interprete / manipulate the data.