Date functions

From: Oliver Otto <ootto_at_genese.de>
Date: Tue, 20 Aug 2002 11:42:08 +0200
Message-ID: <3D620EF0.5D25CFBB@genese.de>

Hi,

maybe someone can explain me this behavior of Oracle. I do not understand the documentation in this.

Doing this :

select benutzer, round(anlagedatum) from zeit_table;

selects a a date from a datetime-column and the names of my users.

Ding this:

select benutzer, round(anlagedatum) from zeit_table where round(sysdate)=round('2002-08-19');

result in an error ORA-001722: invalidate number. I do not understand this. Reading the Documentation I understand ROUND returning a date value. Is it not possible to compare the return values ..?!

Maybe someone can give me a hind. Thanx a lot.

Oliver Received on Tue Aug 20 2002 - 04:42:08 CDT