ORA-01481 : invalid number format model
Hello
could u pls tell me how to subtract two times in format 'HH24:MI':
--------------------------------------------------------------------------------------------
SELECT Round(TO_CHAR(:p_Tmp_Outtime,'HH24:MI') - (TO_CHAR(:P_SH_END_TIME,'HH24:MI'))*24 ,2)
FROM DUAL ;
---------------------------------------------------------
i tried also :
SELECT Round(to_number(TO_CHAR(:p_Tmp_Outtime,'HH24:MI')) - to_number((TO_CHAR(:P_SH_END_TIME,'HH24:MI')))*24 ,2) times
FROM DUAL;
-----------------------------------------------------------------------------------------------------------
i am gettinjg the following ora ORA-01481 : invalid number format model
i can't do any test to the value returned from any table specially date or even from a dual table...!
----------------------------------------------------------------------------------------------------------------
Regards,
Abdetu..