Verifying the format of DATE, TIME, and TIMESTAMP columns
If the row selection criteria you are specifying includes a DATE,
TIME, or TIMESTAMP column, the value you specify (in the Value entry
field) for that column must be in the correct format.
If you are not sure of the format you should use:
Type the required operator (such as =) in the Op entry
field
Type = in the Value entry field
Press Enter
ZDT/Db2 displays the field in the format required, showing the current
value.
For example, if you enter = in the Value entry field for a
TIMESTAMP(4) column, ZDT/Db2 returns
the current date and time in the format required for a TIMESTAMP(4) column:
Cmd Con ( Column name Op Value )
<-> - <---+----1----+----2----+----3----> <-> <---+----1----+----2----+-- -
*** **** Top of data ****
⋮
AND ─ TSTAMP = 2004-09-24-09.19.36.7749
⋮
Note that the last two digits are removed. TIMESTAMP(4) means four digits
of precision.
Using the same format, you can now overtype the value that
ZDT/Db2 returns with the value
you want to use as part of your row selection criteria.