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
Last updated