DURATION function consumes a STRING representing an ISO 8601 duration and pushes back a LONG duration in platform time unit.
The ISO 8601 duration can be expessed as
s.ssssss...seconds Each of these values can be either positive or negative. Each value/unit couple can be omitted if the value is zero but at least one value/couple should be defined.
If the consumed ISO 8601 duration has precision under platform time unit, superfluous digits will be ignored. Prior to revision 2.4, precision below milliseconds were always ignored, independently of platform time unit.