Converting SQL server time to date and time

  • Thread starter Thread starter frogman1001
  • Start date Start date
F

frogman1001

I extracted data from my server. It keeps a log of time like this
1069255091 (this morning)

I converted the data into access but now I need this cell value to b
the actual date and time.

Any one have the easy answer
 
frogman1001 said:
I extracted data from my server. It keeps a log of time like this:
1069255091 (this morning)

I converted the data into access but now I need this cell value to be
the actual date and time.

Any one have the easy answer?
Click to expand...

What kind of field is that? I have never had any problem pulling SQL
Server DateTime fields into Access and having them appear as anything other
than a proper DateTime value.
 
Back
Top