Display Unix Timestamp as Date and Time in MS Access! Please Help!

[ready29003]

Hi, I am using Access to connect to a MySQL database. The database has entries of the format: 1091492019 which somehow represents a date and time stamp in Unix. MS Access sees this as a number. I need to see it in MS Access as a date. How can I get MS Access to do this?

I think the correct description of this is: Getting MS Access to recognize a Unix Timestamp.

Anyone help????

Please?

Matt

 

[WayneRyan]

Matt,

I think this is it:

DateAdd("s", UnixTimeStamp, "1/1/1970")

Wayne

 

[ready29003]

This worked for me:
([date]/86400)+#1/1/1970#