Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Order by empty first
Message
 
 
To
10/09/2017 01:28:00
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Environment versions
SQL Server:
SQL Server 2014
OS:
Windows 8.1
Network:
Windows Server 2012
Miscellaneous
Thread ID:
01654178
Message ID:
01654184
Views:
44
>>SQL Server doesn't have that for dates. It is either NULL or some default value.
>
>This is empty: 1899-12-30 00:00:00.000

Right, that's what I meant by default value. You're sending '' and it's converted into that date. I'd rather have NULL to represent absence of the date.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform