> 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.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.