Re: Not a valid month error

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 30 Mar 2005 06:38:29 -0800
Message-ID: <1112193508.926233.113710@z14g2000cwz.googlegroups.com>

What? How about posting the query or at least a query selecting the date column and reproducing the error?

If you are selecting a date then I would expect you to be using the to_char(datecol,'format') function in the select column list and a to_date function would only appear in the where clause if you were feeding in a character value that represents a date to be compared against.

HTH -- Mark D Powell -- Received on Wed Mar 30 2005 - 08:38:29 CST