I have a SQL 2K db with a table having a datetime column.

I enter data into the table using a VB 6 ADODB Recordset.

When i do not specify a value for the datetime column and save my ADODB recordset, the table shows a value
30th December 1899 12:00:00 a.m.

How do i get rid of this?

Does a datetime column specified as NOT NULL take some kind of null value ????