Results 1 to 1 of 1
  1. #1
    Join Date
    Jun 2004
    Posts
    39

    Unanswered: [Oracle 9.2] error ORA-00907 in a SQL statement

    Hello,

    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))

    Without success...

    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 06:13.
    geoffrey
    - Four J's Development Tools -

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •