Home › Discussions › Questions & Answers › XXEN_UTIL Function for Time Duration Conversion

XXEN_UTIL Function for Time Duration Conversion

Avatar photoCustomer Questions & Answers 3 replies

I have a column representing duration in total seconds (a large number). Is there an `XXEN_UTIL` function to convert this into a human-readable format showing days, hours, and minutes?

3 replies

  • Support Enginatics

    Yes, you should use the function `XXEN_UTIL.TIME(p_seconds in number)`. It takes the number of seconds as input.

  • Avatar photoCustomer

    What is the resulting string format?

  • Support Enginatics

    The result is a string showing the number of days, hours, minutes, and seconds. For example, 361,012 seconds converts to ‘4d 4h 16m 52s’.

  • You must be logged in to reply to this post.