meta data for this page
  •  

F_SECONDS2PERIOD

function from adhoc

Entrypoint seconds2period compatible with UTF-8

Inputs/Outputs

   Input      INTEGER          seconds of a period
   Output     CSTRING(254)     period in pattern d:h:m:s

Syntax

   The output is always in pattern days:hours:minutes:seconds (4 * 2 digit intervals).
   Negative periods start with "-".
   TestSQL
   SELECT '00:01:10:05' AS ISCORRECT, F_SECONDS2PERIOD(4205) FROM RDB$DATABASE;
   SELECT '-00:01:10:05' AS ISCORRECT, F_SECONDS2PERIOD(-4205) FROM RDB$DATABASE;
   SELECT NULL AS ISCORRECT, F_SECONDS2PERIOD(NULL) FROM RDB$DATABASE;