Function ASDURATION
This function converts database duration (see estimate/timestimate etc columns - these fields are simple integer type) to human readable form known from JIRA.
Function takes following parameters:
| Type | Notes |
|---|---|
| BIGINT | Duration in seconds |
Examples
SELECT AUTHOR, AUX.ASDURATION(TIMEWORKED) FORMATED FROM WORKLOGS LIMIT 3
, multiple selections available,