Oracle Database Discussions

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!

DateADD function

446118Sep 7 2006 — edited Sep 7 2006

I'M trying to use DateADD function but i'm hitting a brick wall, its Oracle 9i on Windows 2003 server

SQL> select DateADD('M',1,'31-JULY-2006') from dual;
select DateADD('M',1,'31-JULY-2006') from dual
*
ERROR at line 1:
ORA-00904: "DATEADD": invalid identifier

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 5 2006

Added on Sep 7 2006

#general-database-discussions

4 comments

1,925 views