Home › Discussions › Questions & Answers › XXEN_UTIL Function for Time Conversion
Customer · · Questions & Answers · 5 replies
I have an output column representing duration in total seconds. Is there an `XXEN_UTIL` function that converts this number into a human-readable format like days, hours, and minutes?
Yes, you should use the function **`XXEN_UTIL.TIME(p_seconds in number)`**. It takes a number of seconds as input.
What is the format of the resulting string?
The result is a string showing the number of days, hours, minutes, and seconds, formatted as, for example, ‘4d 4h 16m 52s’.
If I input 3600 seconds, what would the result be?
The SQL statement `select xxen_util.time(3600) from dual` would return ‘1h 0m 0s’.
Sign in with LinkedIn or Google to take part.
