I have a field that records the date as the number of seconds since January 1, 1970.
It is 10 digits.

12:00:01 am on 1/1/1970 would appear as 9 zeros and a 1.

12:01:00 on 1/1/1970 would appear as 8 zeros, a six and then a zero (60 seconds).

I would like to convert this to a date. mm/dd/yyyy hh:ss would be the ideal, but I'm flexible.

Any ideas?