How to find out Hours , Mins and Seconds from Total Seconds from Oracle DB?
Query:
WITH seconds_to_time AS (
SELECT
8222 total_seconds
FROM
dual
)
SELECT
total_seconds,
round(total_seconds / 3600, 0) hours,
mod(round(total_seconds / 60, 0), 60) mins,
mod(total_seconds, 60) seconds,
round(total_seconds / 3600, 0)
|| ':'
|| mod(round(total_seconds / 60, 0), 60)
|| ':'
|| mod(total_seconds, 60) time
FROM
seconds_to_time
Query:
WITH seconds_to_time AS (
SELECT
8222 total_seconds
FROM
dual
)
SELECT
total_seconds,
round(total_seconds / 3600, 0) hours,
mod(round(total_seconds / 60, 0), 60) mins,
mod(total_seconds, 60) seconds,
round(total_seconds / 3600, 0)
|| ':'
|| mod(round(total_seconds / 60, 0), 60)
|| ':'
|| mod(total_seconds, 60) time
FROM
seconds_to_time