Minus Minutes [message #655279] |
Fri, 26 August 2016 01:02 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/cc837b9c65ed1aec0080f5550741ecfe?s=64&d=mm&r=g) |
glmjoy
Messages: 187 Registered: September 2011 Location: KR
|
Senior Member |
|
|
Dear All,
I want to minus minutes from minutes. I run this query which runs sucessfully
Select To_Char(SYSDATE, 'DD/MM/YYYY HH24MI')
from dual
26/08/2016 1055
but when i minus to minutes it gives me error
Select To_Number(To_Char(SYSDATE, 'DD/MM/YYYY HH24MI'))
- To_Number(To_Char(SYSDATE + 10/1440,'DD/MM/YYYY HH24MI'))
from dual;
ERROR at line 1:
ORA-01722: invalid number
I want to minus current minutes with 10 minutes
|
|
|
|
|
|
|
|
|
|
|
|