The duration data type is used to specify a time interval.
The time interval is specified in the following form "PnYnMnDTnHnMnS
" where:
P
indicates the period (required)- n
Y
indicates the number of years - n
M
indicates the number of months - n
D
indicates the number of days T
indicates the start of a time section (required if you are going to specify hours, minutes, or seconds)- n
H
indicates the number of hours - n
M
indicates the number of minutes - n
S
indicates the number of seconds
Example:
P1Y1M1DT1H1M1S
1 Year
1 Month
1 Day
1 Hour
1 Minute
1 Second