You are assuming that the datumod happens at midnight. Are you sure that
that is true?
Jim
"Tijana" <t1jana_at_yahoo.com> wrote in message
news:cbbaf6ba.0308210432.6712e9af_at_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:49:02 CDT
