Re: SQL and to_date problem

Hi Thomas!

Thank you for your answering.

Thomas Kyte wrote:

> To query this and use the index, you may use something like:
> select count(*)
> from ia_artikel
> where ausgabedatum between to_date('28.08.1999','DD.MM.YYYY')
> and to_date('28.08.1999 23:59:59','DD.MM.YYYY HH24:MI:SS')
>
> That will get all of the values on a given date without performing a function on
> the database column.

No! The statement seems to be correct but ... no rows. :-((

Do you know something else which could solve my problem. Maybe a language problem german/english in Oracle?

Bye,
Holger Received on Tue Sep 08 1998 - 14:53:28 CEST