Re: problem in to_date function

The "problem" is that your dates are stored with the time. So, a store date of Aug 21 at 10 AM does not match your where condition, which is searching for Aug 21 at midnight.

There are two solutions: 1) Use a function in the where clause of your query or, 2) originally store the dates using a TRUNC function, so that the time is always 00:00:00.0.

Tim Received on Sat Aug 23 2003 - 16:40:51 CEST