Unanswered: [Oracle 9.2] error ORA-00907 in a SQL statement
When I try to execute the following statement :
SELECT col1 FROM table1 WHERE EXTEND(col_date, YEAR TO MONTH) < EXTEND(col_datetime, YEAR TO MONTH)
I get the error ORA-00907: missing right parenthesis, homever the parenthesis seems ok.
I've also try the following syntax :
SELECT col1 FROM table1 WHERE (EXTEND(col_date, YEAR TO MONTH) < EXTEND(col_datetime, YEAR TO MONTH))
Anyone get an idea ?
EDIT : I find out that it was a bad use of the EXTEND function
Last edited by geoffrey; 07-29-04 at 05:13.
- Four J's Development Tools -