Re: Pet Peeves?

On 2009-01-29, Steve Crawford  wrote:
>
>>> 3. Date handling
>>> Sometimes I've got data with invalid dates and it would be great if it
>>> could replace all the bad ones with, say "0000-00-00".
>>>     

 0000-00-00 doesn't fit in a date column.
 perhaps you could use null?
 
 write a function that casts and catches the exception caused when bad 
 dates are attempted and returens null, use it to translate your data.