Hi.

I have created a table in oracle with the following a field end_date with the type DATE.

in one of my JSP pages, what i want to do is retrieve all of the records in that table that have an end_date > than the current date.
(so i have set up a variable to catch the current date using java.util.Date()).

what i cant do is compare them in my SELECT statement.
i get the following:

SQL> select end_date from gst where end_date >= 06/15/05;
select end_date from gst where end_date >= 06/15/05
                                        *
ERROR at line 1:
ORA-00932: inconsistent datatypes: expected DATE got NUMBER

i also tried:
select gst_rate from gst where end_date > To_Date(01/01/05, 'DD/MM/YY');
but got the error:
ERROR at line 1:
ORA-01858: a non-numeric character was found where a numeric was expected

what do i need to do to be able to get a result from the query?
what im trying to do is get a listing of dates that are after the current date, and then determine which is the closest to the current date. then i can use other data in the table relating to this date.

any help or ideas would be great!
BB

JHELLo, well
in my oracle 9.x i use the date with this format yyyy-mm-dd and works

the error is for syntax but of oracle, i.e

select * from prueba where FECHA=2005-06-06 from dual;

from dual is not the solution, but is a trick of oracle that i saw in some cases
that is nessesary the use for example
select sysdate from dual;
, ask ORACLE FORUM, for the correct syntax,is not a java problem