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.