Duration Codes

The valid duration codes (and their short forms) are:

- DAYS for the day (*D)
- MONTHS for the month (*M)
- YEARS for the year (*Y)
- MSECONDS for the microseconds (*MS)
- SECONDS for the seconds (*S)
- MINUTES for the minutes (*MN)
- HOURS for the hours (*H)

Remarks

Use Years (Y), Months (M) and Days (D) if value is a Date or Timestamp.
Use Hours (H), Minutes (MN), Seconds (S) and MSeconds (MS) when value is a Time or Timestamp .

See Also