I have a date field (test_date) that have null value in it. I am using 2008 R2 server.
the following query return value '1900-01-01' when the test_date field has null value
WHEN isdate(TEST_DATE) = 1 then convert(date, test_date, 120)
I am not sure whey ???