Function ASDURATION

Owned by Piotr Bojko
May 24, 2018
1 min read


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:

TypeNotes
BIGINTDuration in seconds

Examples

SELECT AUTHOR, AUX.ASDURATION(TIMEWORKED) FORMATED FROM WORKLOGS LIMIT 3