Null display as 1/1/1900 3

[krizsy]

I am still having my nullable smalldatetime fields displaying as 1/1/1900. I have many date fields that I don't want anything in. This is on a web based form with asp. I am not sure what to type or where.

 

[Shal2]

In the table design, have you removed the default value?
Shal

 

[amorous]

When inserting into the database the values submitted by the form. Force to insert null when the date field submitted on the form is empty. Something like this:

If request("mydate")="" Then

SQL= Insert Into Tablename(MYdate) Values (NULL)

Else
SQL= Insert Into Tablename(MYdate) Values ('"&request("mydate")&"')

End if

Then you will have NULL entered in the database instead of the default value 1/1/1990


hope that helps

VJ

 

[amorous]

I mean default value 1/1/1900 will be entered into the database when the date field on the form is empty.

VJ

 

[nigelrivett]

datetimes are held as number of days from 1 jan 1900. You are inserting 0 into the field instead of null.
In your asp code you are sending 0 to the database instead of null. You either need to change the asp code to send a null or when you retrive data display 1 jan 1900 as blank.

Almost certainly not a problem with sql server.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.