SQL Developer

Hi

Oracle DB: 9i
SQL Developer Installed on: Windows XP

When I try to execute a SQL statement with bind variables that should be type DATE the SQL developer pops up asking me to enter values for bind variables, however there is no bind variable type that you can specify so when I enter the date I get:

ORA-00932: inconsistent datatypes: expected DATE got NUMBER

Here is my SQL:

select *
from table1
where date1 between :weekstart and :weekend;

The bind variable values I entered were:

weekstart: 11-Sep-2008
weekend: 15-Sep-2008


I am new to SQL Developer, coming from TOAD. In TOAD when entering bind variables, you have to select what the type is, but in SQL developer it justs asks for a value.

Thanks in advance for the help.

Josh