Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Filling SQL date field with empty date?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00851431
Message ID:
00851455
Views:
7
SQL Server does not understand empty dates - make them null.

>my attempts to upload records with an empty date field resulted in SQL Server filling the date field with 01/01/1900. I don't want that so I've been trying to update the records with a blank date. All my attempts have been rejected with complaints about converting the string to a date.
>
>Anyone know the way to do it?
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform