|
-----Original Message----- From: Mark_McCarty@nexnet.navy.mil <Mark_McCarty@nexnet.navy.mil> To: RPG400-L@midrange.com <RPG400-L@midrange.com> Date: Wednesday, August 30, 2000 2:06 PM Subject: sql help >I am attempting to string together a series of numeric fields(MMDDYY) into a >view, is this possible? >The three fields I'm attempting to string are 2,0 numeric. >I have attempted the following: >1> char(mm) || char(dd) || char(yy) which provides spaces between the >numerals. >2> strip (char(mm)) || strip (char(dd)) || strip (char(yy)) which cuts off >the 0's. > char( MM * 10000 + DD * 100 + YY, 6) if you need the leading zero, you may still have a problem since you are converting this to a character representation. =========================================================== R. Bruce Hoffman, Jr. -- IBM Certified Specialist - AS/400 Administrator -- IBM Certified Specialist - RPG IV Developer "Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety." - The Papers of Ben Franklin +--- | This is the RPG/400 Mailing List! | To submit a new message, send your mail to RPG400-L@midrange.com. | To subscribe to this list send email to RPG400-L-SUB@midrange.com. | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.