Date Error Invalid Number

Question

I would like to add 10 minutes to sysdate,

select to_char(SYSDATE,'dd-Mon-yyyy hh:mi:ss') + 10/1440 from dual

when I tried the above I got the error

ORA-01722: invalid number

Answer 1

The error appears because you add 10/1440 to char not to date.

Try this:

select SYSDATE + 10/1440 from dual;

or

select to_char(SYSDATE+ 10/1440,'dd-Mon-yyyy hh:mi:ss')  from dual;

or

select to_char( sysdate + interval '10' minute,'dd-Mon-yyyy hh:mi:ss')  
from dual;

Here you can find more information.

Here you can find similar problem on SO, there are more solutions.

Answer 2

You don't need to "to_char" the date first.

Either

select SYSDATE + 10/1440 from dual;

or

select to_char(SYSDATE + 10/1440,'dd-Mon-yyyy hh:mi:ss') from dual;

depending on whether you just want a date or a string representation of the date formatted in a certain way.