SQL Programming Manual for TAL

Error and Status Processing
HP NonStop SQL Programming Manual for TAL—527887-001
6-20
Using Literal Declarations for the SQLDA
DAY TO MINUTE 203 _SQLDT_INT_D_MI
SECOND TO SECOND 204 _SQLDT_INT_S_S
MINUTE TO SECOND 205 _SQLDT_INT_MI_S
HOUR TO SECOND 206 _SQLDT_INT_H_S
DAY TO SECOND 207 _SQLDT_INT_D_S
FRACTION TO FRACTION 208 _SQLDT_INT_F_F
SECOND TO FRACTION 209 _SQLDT_INT_S_F
SECOND TO FRACTION 209 _SQLDT_INT_S_F
MINUTE TO FRACTION 210 _SQLDT_INT_MI_F
HOUR TO FRACTION 211 _SQLDT_INT_H_F
DAY TO FRACTION 212 _SQLDT_INT_D_F
Table 6-7. Literal Declarations for Ranges of Date-Time Fields (page 1 of 2)
Range of Fields Value Literal Declaration
YEAR TO YEAR 1 _SQLDT_INT_QUAL_Y_Y
MONTH TO MONTH 2 _SQLDT_INT_QUAL_MO_MO
DAY TO DAY 3 _SQLDT_INT_QUAL_D_D
HOUR TO HOUR 4 _SQLDT_INT_QUAL_H_H
MINUTE TO MINUTE 5 _SQLDT_INT_QUAL_MI_MI
SECOND TO SECOND 6 _SQLDT_INT_QUAL_S_S
FRACTION TO FRACTION 7 _SQLDT_INT_QUAL_F_F
YEAR TO MONTH 8 _SQLDT_INT_QUAL_Y_MO
YEAR TO DAY 9 _SQLDT_INT_QUAL_Y_D
YEAR TO HOUR 10 _SQLDT_INT_QUAL_Y_H
YEAR TO MINUTE 11 _SQLDT_INT_QUAL_Y_MI
YEAR TO SECOND 12 _SQLDT_INT_QUAL_Y_S
YEAR TO FRACTION 13 _SQLDT_INT_QUAL_Y_F
MONTH TO DAY 14 _SQLDT_INT_QUAL_MO_D
MONTH TO HOUR 15 _SQLDT_INT_QUAL_MO_H
MONTH TO MINUTE 16 _SQLDT_INT_QUAL_MO_MI
MONTH TO SECOND 17 _SQLDT_INT_QUAL_MO_S
MONTH TO FRACTION 18 _SQLDT_INT_QUAL_MO_F
DAY TO HOUR 19 _SQLDT_INT_QUAL_D_H
DAY TO MINUTE 20 _SQLDT_INT_QUAL_D_MI
Table 6-6. Literal Declarations for Date-Time and INTERVAL Values (page 2 of 2)
Type of Data Value Literal Declaration