MySql date conversion

[laura]

I am working with an Invision Messageboard where I want to download the
information about the members who post messages for analysis purposes. I
have been able to run a Query and save the Query as an MDB file.
Unfortunately the date field is driving me crazy. It's a int(10) field and
the date is stored as a very long number, i.e., 1066228160. There are
several date fields, date joined, date of last message etc.

I cannot figure out how to convert those numbers to a valid date and time. I
believe that they are something like "timestamp" which is the number of
seconds since 1 Jan 1970 (unix time). Does anyone know anything about this
and if there is a function to convert these numbers to a date and time?

Laura TD

 

[Marshall Barton]

I am working with an Invision Messageboard where I want to download the
information about the members who post messages for analysis purposes. I
have been able to run a Query and save the Query as an MDB file.
Unfortunately the date field is driving me crazy. It's a int(10) field and
the date is stored as a very long number, i.e., 1066228160. There are
several date fields, date joined, date of last message etc.

I cannot figure out how to convert those numbers to a valid date and time. I
believe that they are something like "timestamp" which is the number of
seconds since 1 Jan 1970 (unix time). Does anyone know anything about this
and if there is a function to convert these numbers to a date and time?

DateAdd("s", unixdatevalue, #1/1/1970#)

 

[laura]

Thank you - brilliant
Laura

DateAdd("s", unixdatevalue, #1/1/1970#)