Re: Oracle7 Date comparison question

Your problem is the time portion, which has a resolution to the seconds level. Use TO_DATE (<date_value>, 'DD-MON-YYYY') when comparing like this, so the time portion is ignored.

abrusko wrote:

> HI,
> I am comparing date columns from 2 different tables and
> expecting a match, however the values are not matching
> during the query.
> Viewing the columns thru separate queries shows values that
> are identical, but no match occurs during the query:
> Update Frt.Sardown a
> Set (month, year) =
> (Select b.month, b.year from Frt.Frt_Date b
> where a.shipdate = b.frt_date);
>
> Is it because the "time" portion of the date field is not
> matching? If so, how do I code this so that I get a match?
>
> Thanks very much for your help...
> Andy
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Thu Jul 29 1999 - 09:22:38 CDT