Re: Oracle7 Date comparison question

What about using trunc()?

update frt.sardown a set (month, year) = (select b.month, b.year from frt.frt_date b where trunc(a.shipdate) = trunc(b.frt_date));

Volker

abrusko wrote:
>
> 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?
Received on Thu Jul 29 1999 - 10:16:53 CDT