Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Question on blank dates...
Message
 
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Miscellaneous
Thread ID:
00763437
Message ID:
00763456
Views:
15
Hi Kevin,

Sql Server doesn't support empty/blank dates. Nulls usually used to represent unknown dates.

>Is there any way to easily interpret a 'blank date' value from a SQL Server table into an ADO.NET table?
>
>It seems that blank dates come back as 1/1/1900. Other than writing code that checks for that, is there a better way to handle this? [In other words, in VFP I could easily do a test for empty dates with the EMPTY() function]
>
>
>Thanks,
>Kevin
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform