IBM ISERIES SC41-5210-04 - Manual (Page 34)

Query for iSeries date . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67
Query for iSeries time . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 67
Query for iSeries timestamp
. . . . . . . . . . . . . . . . . . . . . . . . . . 68
Displaying constants format in Query for iSeries . . . . . . . . . . . . . . . . . . . . 69
Date, time, and timestamp arithmetic operations in Query for iSeries . . . . . . . . . . . . . 69
Date arithmetic operation in Query for iSeries . . . . . . . . . . . . . . . . . . . . . 70
Subtracting dates in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . 70
Incrementing and decrementing dates in Query for iSeries . . . . . . . . . . . . . . . 71
Converting a numeric field to a date field in Query for iSeries . . . . . . . . . . . . . . 71
Working with numeric dates in Query for iSeries . . . . . . . . . . . . . . . . . . . 71
Time arithmetic operation in Query for iSeries . . . . . . . . . . . . . . . . . . . . . 73
Incrementing and decrementing times in Query for iSeries . . . . . . . . . . . . . . . 73
Timestamp arithmetic operation in Query for iSeries . . . . . . . . . . . . . . . . . . 73
Durations in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . . . . 73
Labeled duration in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . 73
Date duration in Query for iSeries
. . . . . . . . . . . . . . . . . . . . . . . . 73
Time duration in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . 73
Timestamp duration in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . 74
Date, time, and timestamp functions in Query for iSeries . . . . . . . . . . . . . . . . . . 74
CHAR Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . . 74
DATE Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . . 75
DAY Query for iSeries function
. . . . . . . . . . . . . . . . . . . . . . . . . . 75
DAYS Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . . 76
HOUR Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . . 76
MICROSECOND Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . 77
MINUTE Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . 77
MONTH Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . 78
SECOND Query for iSeries function. . . . . . . . . . . . . . . . . . . . . . . . . 78
TIME Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . . 79
TIMESTAMP Query for iSeries function
. . . . . . . . . . . . . . . . . . . . . . . 79
YEAR Query for iSeries function . . . . . . . . . . . . . . . . . . . . . . . . . . 80
Additional date, time, and timestamp functions in Query for iSeries . . . . . . . . . . . . . 80
Converting date formats in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . 80
Converting date for output to a database file in Query for iSeries . . . . . . . . . . . . . . 80
Converting date for output to a display or printer in Query for iSeries
. . . . . . . . . . . . 81
Example 1—Converting from MMDDYY to YYDDD format in Query for iSeries . . . . . . . . 81
Example 2—Converting from MMDDYY to YYDDD format in Query for iSeries . . . . . . . . 81
Example 3—Converting from YYDDD to MMDDYY format in Query for iSeries . . . . . . . . 82
Example 4—Converting from MMDDYY to YYDD format in Query for iSeries
. . . . . . . . 82
General considerations when creating an expression in Query for iSeries . . . . . . . . . . . . 83
Column headings in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . . 85
Length and decimal positions in Query for iSeries
. . . . . . . . . . . . . . . . . . . . 85
Example of defining a result field in Query for iSeries . . . . . . . . . . . . . . . . . . 86
Adding or removing result fields in Query for iSeries . . . . . . . . . . . . . . . . . . . 86
Chapter 6. Selecting and sequencing fields in Query for iSeries . . . . . . . . . . . . . . 87
Letting Query for iSeries select and sequence fields. . . . . . . . . . . . . . . . . . . . 87
Selecting fields and specifying their sequence in Query for iSeries . . . . . . . . . . . . . . 87
Chapter 7. Selecting records in Query for iSeries . . . . . . . . . . . . . . . . . . . 91
Letting Query for iSeries select records . . . . . . . . . . . . . . . . . . . . . . . . 91
Selecting the records you want in Query for iSeries . . . . . . . . . . . . . . . . . . . . 91
Comparison fields in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . . 92
Comparison values in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . 93
Fields as values in Query for iSeries . . . . . . . . . . . . . . . . . . . . . . . 94
Character constants as values in Query for iSeries . . . . . . . . . . . . . . . . . . 94
22 Query for iSeries Use V5R2