What Does DB@ Date function return for invalid date string
Posted on 2013-12-04
The column mycolumn in table mytable is varchar(10) and has entries like 01/01/2013. However some rows have invalid data in mycolumn, e.g. 'garbage'
The following sql statement shows IsDate=1 for good dates but does not show 0 for invalid dates. What am I doing wrong?
Date(mycolumn) as mydate,
case when Date(mycolumn) is null then 0 else 1 end as IsDate