Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-16 : 13:14:54
|
| Susan writes "I have an asp form where people can edit fields. There are several smalldatetime fields (textboxes) on the form which are updated when the user submits the update button. My problem is, if the date fields are null the fields are being updated with 1/1/1900. Even though I am allowing nulls in the table and the default is (null). I have tried form validation where IF thedate = "" then thedate = null, but it still updates it with 1/1/1900. Is there a way around this in SQL Server or some type of script that I can use?" |
|
|
|
|
|
Date field is null but update statement adds 1/1/1900 as default.