PARSE_DURATION

Parses strings with a number followed by a unit abbreviation into an interval. Supported units are d, h, m, s, ms, us, and ns. For example, the string 30m will be parsed into an interval of 30 minutes.

Syntax

PARSE_DURATION(value)

Arguments

Name	Type	Description	Default Value
value	string	The string representation of the interval to be parsed

Returns

interval day to second

Examples

value	Output
'6500000ns'	interval '7' millisecond
'6500us'	interval '7' millisecond
'6.5 ms'	interval '7' millisecond
'6.5s '	interval '6500' millisecond
' 6.5m'	interval '390' second
'6.5h'	interval '390' minute
'6.5d'	interval '156' hour

Transformation job example

SQL

CREATE JOB function_operator_example
    ADD_MISSING_COLUMNS = true
AS INSERT INTO default_glue_catalog.upsolver_samples.orders_transformed_data 
  MAP_COLUMNS_BY_NAME
    SELECT value,
        PARSE_DURATION(value) AS Output
    FROM default_glue_catalog.upsolver_samples.orders_raw_data
    LET value = '6500000ns'
    WHERE $commit_time BETWEEN run_start_time() AND run_end_time()
    LIMIT 1;

Query result

value	Output
'6500000ns'	interval '7' millisecond