Re: WRKQRY question

[MacWheel99@xxxxxxx]

> We have file with date format yyyymmdd. When I use the function
>  current(date) in wrkqry, is there a way to get the current date in that
>  format? By default it appears as mm/dd/yy.

By default it uses your *JOBD Job description, which you can change, but it
is simpler to leave everything in sync with your system defaults & make some
changes in how a query manipulates the date ... something I call DATE MATH.

You might want to check the archives of the DB2 discussion groups on this via
http://www.as400network.com/Forums/Main.cfm?CFApp=59
http://clubs.yahoo.com/clubs/as400support

since a lot of people have a lot of tips on what can be done.

The IBM Query/400 User's Reference Guide, whose code # I not have handy, has
many pages on this topic.  You basically convert a date format field so it
shows up in whatever format you want ... in which we like yyyy-mm-dd &
mm/dd/yy

Careful about the yyyymmdd data ... some applications have date fields that
are not defined as IBM date fields because they have some non-date data in
there, so you may need to convert the field.

MacWheel99@aol.com (Alister Wm Macintyre) (Al Mac)