Minus Minutes [message #655279] |
Fri, 26 August 2016 01:02 |
|
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
|
|
|
|
|
|
|
|
|
|
|
|