Nick Wiltshire wrote: > Hi all, > > I have a varchar field in a table which contains dates in yyyy-mm-dd > format. The problem is that some have entered invalid dates like > 1975-01-00 and I want to convert it to a date field to avoid this > nonsense. Is there a way to test for failure of a type conversion and > insert a NULL on failure? >
Not the question you asked, but perhaps a suitable alternative: before attempting to convert, scan all the rows in the table looking for any contents of that column not fitting the format yyyy-mm-dd. Then you can either fix them or null them out. -- Guy Rouillier ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
