In SQL 2000, default dates (those inserted with a '' as opposed to those explicitly set to NULL) are saved as
1900-01-01 00:00:00.000
If I use the following query, I can extract those dates:
select * from tmp where
convert(char(8), testDate, 108) = '00:00:00'
The format mask 108 is used to...