Links
Comment on page

PARSE_DURATION

Parses strings with a number followed by a unit abbreviation into an interval. Supported units are d, h, m, s, ms, us, 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 time_filter()
LIMIT 1;

Query result

value
Output
'6500000ns'
interval '7' millisecond