Handling DATE, TIME, and TIMESTAMP information
You can also use the edit code exit to format date, time,
and timestamp values.
If your installation supports date/time data types, you can format
columns with data types of DATE, TIME, and TIMESTAMP. This enables
your users to use local date/time exit routines. For more information
about these data types, see the Using QMF manual.
You need to remember that these are DB2, not QMF exits. For details
about how these exits are created refer to the appropriate DB2 System Administration manual.
Your edit routine can format data from these columns, just as
it can format data from columns of the other data types. The one
difference is that the value to be formatted, which appears in the
control block field ECSINPT, is always passed as a character string,
whether the code to be processed is a U code or a V code. The format
of the string is described in Table 68.
Table 68. Formatting DATE, TIME, and TIMESTAMP data
Data type |
Form of the string |
DATE data |
yyyy-mm-dd where:
- yyyy
- Specifies the year. It is always a four-digit number.
- mm
- Specifies the month ( 01 for January, ... 12 for December).
It is always a two-digit number that can contain a leading zero.
- dd
- Specifies the day of the month. It is always a two-digit number
that can contain a leading zero.
The dashes (-) represent true dashes.
For example, 1990-12-12 is the date December 12, 1990. |
TIME data |
hh.mm.ss where:
- hh
- Specifies the hour (based on a 24-hour clock, from 00 to 23).
It is always a two-digit number that can contain a leading zero.
- mm
- Specifies the minute. It is always a two-digit number that
can contain a leading zero.
- ss
- Specifies the second. It is always a two-digit number that
can contain a leading zero.
The periods represent true periods.
For example, 13.08.36 is 1:08 P.M. and 36 seconds in the notation commonly
used in the United States. |
TIMESTAMP data |
yyyy-mm-dd-hh.mm.ss.nnnnnn where:
- yyyy-mm-dd
- Specifies the date in the same way it does for DATE data.
- hh.mm.ss
- Specifies the time of day in the same way it does for TIME
data.
- nnnnnn
- Specifies a six-digit number that extends the count of seconds
(ss) down to the nearest microsecond.
For example, 1990-12-12-13.08.36.123456 is 1:08 P.M. and 36.123456
seconds on December 12, 1990, in the notation commonly used in the
United States. |
For the data types available, see the ECSINTYP field in Table 69.
[ Previous Page | Next Page | Contents | Index ]