CURRENT Date/Time

All Date, Time, and Timestamp columns let you enter the keyword CURRENT, or its abbreviation CUR. The current date, time, timestamp (TMSTMP), or timestamp with time zone (TMESTZ) is then filled in as appropriate. A user default option is provided so that current time is local or Greenwich Mean Time (GMT). This option is set with the PROFILE primary command (see PROFILE-PRO). To put values in these columns, use the following formats:

DATE=yyyy-mm-dd

TIME=hh.mm.ss

TMSTMP=yyyy-mm-dd-hh.mm.ss.nnnnnnnnnnnn

TMESTZ=yyyy-mm-dd-hh.mm.ss.nnnnnnnnnnnn±HH:MM

where yyyy is year, mm is month, dd is day, hh is hour, mm is minute, ss is second, nnnnnnnnnnnn is a variable precision value from 0 to 12 positions (up to picosecond), ±HH:MM is the time zone. For Db2 Versions prior to Version 10, the length (precision) is always 6 (microsecond).

Important

In addition to using a dash to separate the date portion and the time portion of the timestamp string, you can also use a blank as a separator. The format for a blank separator is: yyyy-mm-dd hh.mm.ss.nnnnnn

Date and time fields are displayed in the default format defined at your site.File-AID for Db2 accepts any valid format, such as European or USA. File-AID for Db2 validates all date, time and timestamp fields and issues appropriate error messages before sending the fields to Db2.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*