Parameter | Description |
---|---|
quantity | The value representing the number of units |
unit | - Year, month, day, hour, minute, etc. - Abbreviations, short forms and dash format is supported - Plural forms are also acceptable (e.g. months, days, weeks) |
direction | An optional parameter: ago or empty string |
OPTION | Additional options when parsing interval |
Unit | Abbreviations |
---|---|
Millennium | - |
Century | - |
Decade | - |
Year | y , yr , yrs |
Month | - |
Week | - |
Day | d |
Hour | h , hr , hrs |
Minute | min , mins , m |
Second | s , sec , secs |
Millisecond | ms |
Microsecond | - |
YEAR
, MONTH
, DAY
, HOUR
, MINUTE
, SECOND
YEAR TO MONTH
, DAY TO HOUR
, DAY TO MINUTE
, DAY TO SECOND
, HOUR TO MINUTE
, HOUR TO SECOND
, MINUTE TO SECOND
field
: supports time units, such as YEAR
, MONTH
, DAY
, HOUR
, etc.interval
: specified timestamp.0
as an output.