SQL Programming Manual for Pascal

Error and Status Processing
HP NonStop SQL Programming Manual for Pascal—528614-001
6-20
Data Type Literals
Table 6-7 shows the literals defined to represent ranges of date-time fields.
Table 6-6. Literals for Date-Time and INTERVAL Data Types
Literals for Date-Time Data Types
Type of Data Value Pascal Literal
General DATETIME 192 SQLDT_DATETIME
Literals for INTERVAL Data Types
Type of Data Value Pascal Literal
YEAR TO YEAR 195 SQLDT_INT_Y_Y
MONTH TO MONTH 196 SQLDT_INT_MO_MO
YEAR TO MONTH 197 SQLDT_INT_Y_MO
DAY TO DAY 198 SQLDT_INT_D_D
HOUR TO HOUR 199 SQLDT_INT_H_H
DAY TO HOUR 200 SQLDT_INT_D_H
MINUTE TO MINUTE 201 SQLDT_INT_MI_MI
HOUR TO MINUTE 202 SQLDT_INT_H_MI
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
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 Pascal Literal
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