Skip to Main Content
Forums

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!

DAYS_BETWEEN

894559Oct 14 2011 — edited Oct 14 2011
Hello,

According to:

[http://download.oracle.com/docs/cd/A60725_05/html/comnls/us/per/ffugax15.htm]

There's a DAYS_BETWEEN function. I tried this:

SELECT DAYS_BETWEEN('27-JUN-1995', '03-JUL-1995') FROM DUAL

I get the following:

ORA-00904: "DAYS_BETWEEN": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
Error at Line: 1 Column: 7

Any idea what I'm doing wrong?


-Eric
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 11 2011
Added on Oct 14 2011
10 comments
25,413 views