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#)
 
You must log in or register to reply here.

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

Which is the best MBOX Converter Tool different formats conversion? 4
Numeric Field Overflow when appending date - how to convert it to text 1
How can I migrate MBOX to PST? 2
Date Conversion 4
Formatting date gives bad results in query 2
Text to Date conversion 3
Format Cells in a query created using SQL 3
Converted from LINUX time ok, but having issues with the between date. 4

Back
Top