Variables for binary qualifiers
You can use string qualifiers to manipulate INTERVAL data types, but using binary qualifiers results in faster performance. The following variables are defined in the Interval base class and represent the time unit (start and end code) of a field in the binary qualifier. To use these variables, instantiate objects of the IntervalYM and IntervalDF classes, which inherit these variables from the Interval base class.
- TU_YEAR
- Time unit for the YEAR qualifier field
- TU_MONTH
- Time unit for the MONTH qualifier field
- TU_DAY
- Time unit for the DAY qualifier field
- TU_HOUR
- Time unit for the HOUR qualifier field
- TU_MINUTE
- Time unit for the MINUTE qualifier field
- TU_SECOND
- Time unit for the SECOND qualifier field
- TU_FRAC
- Time unit for the leading FRACTION qualifier field
- TU_F1
- Time unit for the ending field of the first position of FRACTION
- TU_F2
- Time unit for the ending field of the second position of FRACTION
- TU_F3
- Time unit for the ending field of the third position of FRACTION
- TU_F4
- Time unit for the ending field of the fourth position of FRACTION
- TU_F5
- Time unit for the ending field of the fifth position of FRACTION