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:
00539501
Views:
15
Okay, I'll use that date as my empty then.

Thanks again.
Terry

>No there isn't. If you insert 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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform