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.
PARSE_DURATION(value)
Name | Type | Description | Default Value |
---|---|---|---|
value | string | The string representation of the interval to be parsed | |
interval day to second
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 |
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;
value | Output |
---|---|
'6500000ns' | interval '7' millisecond |
Last modified 3mo ago