Hi Expert,
i | o |
---|
06/05/2013 09:56:00 AM | 07/05/2013 09:48:00 AM |
08/05/2013 10:26:00 AM | 08/05/2013 05:33:00 PM |
10/05/2013 10:10:00 AM | 11/05/2013 05:31:00 AM |
14/05/2013 09:40:00 AM | 14/05/2013 05:39:00 PM |
17/05/2013 09:41:00 AM | 17/05/2013 07:36:00 PM |
28/05/2013 09:39:00 AM | 29/05/2013 09:39:00 AM |
I want to do concatenate string with number , example I have 6 i want to add 0 before 6 result 06.
see query
select
case
when (floor(((o-i)*24*60*60)/3600)) > 9 then
floor(((o-i)*24*60*60)/3600)
else
0 || to_char(floor(((o-i)*24*60*60)/3600))
End
Wh
from T
showing error ORA-00932 inconsistent datatypes:
please guide.