Date Conversion...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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
 
You can convert this to a date by using the expression in a query:
TheDateTime:DateAdd("s", [SQLField],#1/1/1970#)
 
Back
Top