> 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)


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.