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!

DATE SUBTRACTION

1044098Feb 24 2014 — edited Feb 24 2014

I know date to date subtraction is possible in oracle but when ever i am trying to do

i am getting this error


SQL> SELECT (SYSDATE-'25-APR-91') FROM DUAL;

SELECT (SYSDATE-'25-APR-91') FROM DUAL

                *

ERROR at line 1:

ORA-01722: invalid number

Please give a correct way to d that...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 24 2014
Added on Feb 24 2014
5 comments
22,395 views