8 Replies Latest reply on Dec 22, 2008 8:48 PM by 676874

    datediff error


      i tried to run this query,

      select datediff( 'DD', '01-Jan-2004 22:00:00', '01-May-2004 06:00:00' ) from dual

      but it shows me an error message while executing the codes.
      ORA-00904: "DATEDIFF": invalid identifier

      why is it that way? does the error message associate with the oracle version i am using, Oracle 9i? or there is something wrong with the codes?