ctime conversion in Access

[Ulrich]

I am working eith a database (over ODBC linked tables)
that shows date and time values as ctime (seconds since
00:00 on January 1st 1970)

For my queries and reports, I need to convert these
values from ctime format into normal date / time format.

Can anyone tell me how to do this?


Thanks,


Ulrich
..

 

[Allen Browne]

Try an Update query using:
DateAdd("s", [MyCtimefield], #1/1/1970#)

 

[Phobos]

CDate(([Fld]/(86400))+25569)

Where Fld is the name of the field that contains the number of seconds since
midnight on 01/01/1970.

P