Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle 9i: comparison of DATEs

Oracle 9i: comparison of DATEs

From: Tijana <t1jana_at_yahoo.com>
Date: 21 Aug 2003 05:32:48 -0700
Message-ID: <cbbaf6ba.0308210432.6712e9af@posting.google.com>


Why is it that a query which looks like this:

select * from akcizastopa
where sifra = '777' and datumod = to_date('20.06.2003', 'DD.MM.YYYY')

returns one row, while

update akcizastopa
set iznos = 5
where sifra = '777' and datumod = to_date('20.06.2003', 'DD.MM.YYYY')

doesn't update any rows?

Please note that the where clause is identical. The contents of the table were also identical at the times I ran the queries.

Thanks Received on Thu Aug 21 2003 - 07:32:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US