IBM SC41-5210-04 manual Selecting and sequencing fields in Query for iSeries

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

22Query for iSeries Use V5R2