SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

datediff error

535323Aug 3 2007 — edited Dec 22 2008

hi,

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?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 19 2009

Added on Aug 3 2007

8 comments

3,986 views