ctime conversion in Access

U

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
 
P

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
 
P

PostalPete

I'm working on a database that needs to convert standard time to ctime.
Does anyone have any suggestions.



Cheers



Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ctime conversion in Access 2
SQL to query columns that are in seconds since 1/1/1970 6
Converting UTC timestamp value to date and time 1
timestamps in excel 4
Definitively, dates don’t work within WHERE clauses 9
Date storage 3
ODBC Connection problems 3
Adjusted Date/Time 4

Top