Home Discussions Questions & Answers XXEN_UTIL Function for Time Duration Conversion

XXEN_UTIL Function for Time Duration Conversion

Avatar photoCustomer September 12, 2024 at 12:39 am

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?

Viewing 2 reply threads
  • Author
    Replies
    • Support September 14, 2024 at 3:10 am  

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

    • Avatar photoCustomer September 15, 2024 at 6:20 am  

      What is the resulting string format?

    • Support September 16, 2024 at 4:06 am  

      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’.

Viewing 2 reply threads
  • You must be logged in to reply to this post.

Login with: