Insert DateTime.Now into SqlServe adds 2 days to date?

[gazzeruk]

Hi,

Had this years ago and can't remember how I solved it!

I want to timestamp some events with my own DateTime derived time (not the auto sql TimeStamp!). When I save DateTime.Now into an sql server DateTime field - and view this field, it shows the date+2days and the correct time - why!

Cheers,

Gary

 

[gazzeruk]

OK...

Looked at a bit further and I forgot to mention that I am converting the datetime using the function ToOADate() - which converts a .net DateTime to a double - as apparently required by sql server.

I am guessing that the Date representation in the DateTime starts 2 days behind the OLE DateTime representation and so if I save the following: DateTime.Now.ToOADate()-2 to an sql server DateTime field the correct date is saved.

The above works fine - but is my logic correct!

cheers...

Gary