Converting Unix time

[Anon]

I have info that has been dumped into Foxpro...One of the columns is a date/time stamp in Unix format. I need to create a new column with the date/time info in a normal date format. Any ideas on how I can accomplish this?!?!

[cornelalexa]

Export the data from Fox into a CVS text file, then write a script to acomplish this:
1.Read the file line by line, and split the fields based on the separator (Tab key,or 😉
2.Convert the unix timestamp into a normal date.(see Date Time function in Php manual)
3.Insert the data into the MySql database(row by row).

I'm sure there are other ways too.This is in my mind now.
Hope to help.
Bye.