Dear All,
In my work I have to get the time in the form of hh:mm:ss(hours,minutes,seconds) from database. For this I wrote a query like this:
select (call_end_time - call_called_time)from <A table name>;
it is returning me time like 202 or 104 which indicates the time difference is 2min-2sec or 1min-4sec. But how can I get the time in the form of hh:mm:ss from the database? Can anybody help me in this issue?
regards,
Indrajit.
