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?
Thanks,
Nick
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
