Converting datetime to double

J

John Dann

I need to convert some datetime data currently stored in .Net DateTime
type to the older double style (for compatibility with a legacy
control). Is there an intrinsic function to do this or, if not, could
someone please enlighten me as to the algorithm that would be needed
to code the conversion explicitly.

TIA
John Dann
 
K

Ken Tucker [MVP]

Hi,

Take a look at the datetime ToOADate method.

http://msdn.microsoft.com/library/d...tml/frlrfSystemDateTimeClassToOADateTopic.asp

Ken
------------------
I need to convert some datetime data currently stored in .Net DateTime
type to the older double style (for compatibility with a legacy
control). Is there an intrinsic function to do this or, if not, could
someone please enlighten me as to the algorithm that would be needed
to code the conversion explicitly.

TIA
John Dann
 

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

Converting an empty textbox to a null datetime field... 1
Converting DateTime format when retrieving a dataset 1
Converting a DateTime() to a Double?! 1
Error converting data type nvarchar to datetime - Please help 1
Conversion of .NET DateTime to SQL datetime via VarBinary 1
.NET Marshalling Optimization - FILETIME conversion 2
Casting a datetime to double ?! 2
Converting a Double to DateTime 20

Top