Date Conversion...

J

Jim

I have tables that are linked to a SQL Server DB that stores the date in a
numeric format (example: 1092432704). I need to convert this to a date
format. If I paste the data into Excel and change the cell format to date,
it changes it correctly. Anyone know the command in SQL or the function to
do this?

Thanks,

Jim
 
D

Duane Hookom

Pasting into Excel doesn't work for me with Office 2002. What date value is
the number? How is it calculated from the example number?
 
J

Jim

The number should represent 8/13/2004 4:31:44PM. I don't know the
calculation as the database is attached to a 3rd Party application.

Jim
 
D

Duane Hookom

You can convert this to a date by using the expression in a query:
TheDateTime:DateAdd("s", [SQLField],#1/1/1970#)
 
Top