[dba-VB] OT?: How to load null date to SQL2000 from VB

Randall R Anthony RRANTHON at sentara.com
Fri Jun 17 11:23:16 CDT 2005

Simply put, if I use a simple insert query:

Insert into tablename (field1, fielddate) values ("bob", '')
My table will show field1 = bob, and fielddate = 1/1/1900.

I've seen all kinds of .Net workarounds, but none work for VB6.0.
Any help is appreciated.  Thanks.

More information about the dba-VB mailing list