usually, if the column is defined as datetime(), you would use the 1-1-1901 as the default value mining NULL/EMPTY.
you can use the datediff to assess or use that info in your query.
it is common that vendor use the 1-1-1901 as a null date or they use a date that is more than a 100 years from the software design depending on what the date is for, i.e. you might se 1-1-1901 currently it accounts for people whose age is approaching 120.
arnold
One option is to use case and substring (column_name,0,10)
Try the following, to convert it to Varchar. The following does also convert it to the current date time if it is null.
Open in new window