Printable View
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 ????
:confused:
How are you setting the value for column in recordset?
If you have defined the column as not null then check if you have a default defined on it.
If your recordset puts 0 or '' for date column then it is saved as 1/1/1900 by sql server.
thanx for the reply.
Actually this problem occurs when i do not enter a value for the column in the recordset i.e. something like
1. On Error Resume Next
2. rs("DateCol") = ''
3. rs.Update
The above code encounters an error in line 2. but because of line 1. it moves on to execute line 3.
This is not very elegant coding i aggree but it cant be avoided.
:p
I believe .net handles date from dec 30 1899.
see the below links
http://www-rcf.usc.edu/~anthonyb/itp150/2000.htm
you can avoid this by hardcoding the datetime value
1. On Error Resume Next
2. rs("DateCol") = '01/01/1900'
3. rs.Update