Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Empty date value
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00539497
Message ID:
00539500
Views:
16
No there isn't. If you insert an empty date from QA it gets converted to 01/01/1900.

>So as to not have a null date field, is there an empty date value like '' for string or 0 for numeric or decimal that can be used as a default value for a field?
>
>Something better than using an old date like 1/1/1800?
>
>Thanks
>Terry
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform