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:

  1. Type the required operator (such as =) in the Op entry field
  2. Type = in the Value entry field
  3. Press Enter

FM/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, FM/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 FM/Db2 returns with the value you want to use as part of your row selection criteria.

Related tasks

Related references