Re: Help required with to_date function

Write a function that converts the string to a date. Trap exceptions in the function, have it return to_date(null) or whatever is appropriate for your ordering purposes whenever to_date fails. Use the function in your query or, if you are using jdbc and that causes problems, use a view. Received on Tue Jan 13 2004 - 15:17:42 CST