Null dates

[zerkat]

Has any one had this problem -

When SQL server returns a null date, it is returned as 12:00:00 AM? I have coded around this in our website but never encountered it before and was not sure why it was working that way.

Thanks.

 

[jbenson001]

Nulls are returned as nulls. What is the code you are executing?

 

[ca8msm]

Dates aren't nullable objects so if you are using a date object then yes you will see it as "01/01/0001 00:00:00" (which is the same as what wrote above).

Mark,

[URL unfurl="true"]http://lessthandot.com[/url] - Experts, Information, Ideas & Knowledge
[URL unfurl="true"]http://mdssolutions.co.uk[/url] - Website Design
[URL unfurl="true"]http://aspnetlibrary.com[/url] - An online resource for professional ASP.NET developers