Oracle7 Date comparison question

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!