Re: Comparing Date - Problem

Tom Miskiewicz wrote:

> Hi!
>
> I got stuck with this:
>
> SELECT Request_ID FROM Test WHERE StartDate > TO_DATE('02.10.2003',
> 'DD.MM.YYYY');
>
> *
> ERROR at line 1: ORA-00932: inconsistent datatypes
>
> I also tried a number of other options like TO_NUMBER(TRUNC(TO_DATE...,
> TRUNC(TO_DATE etc. Same problem.

Are you sure the STARTDATE column is a DATE data type? Do a describe on the TEST table.

--
Richard Kuhler