Selecting time format from DB

[Anon]

Dear all,
In my work, I have to select time from database in the form of hh:mm:ss(hours,minutes,seconds). For this I wrote a query like this:

select ((call_log_end_time - extract(hour_second from call_log_date_and_time_called))) from <A table name>.

This query is returning me the time in the form of 104 or 205(means 1min-04sec or 2min-05sec). How can I get the time in the form of hh:dd:ss while retriving it from database? Can anybody help me in this issue?
regards,
Indrajit.

[[deleted]]

Most databases have functions for calculating with dates, but many allow you to do normal math on them.

Check your database's SQL manual.