MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2008

Re: SQL guru question



fixed

If it's the
Jun 5 2008
Then I suggest writing a UDF in RPG and passing that back.
http://faq.midrange.com/data/cache/185.html
Then basically it's
- Looking up the three character alpha against a 12 element array.
- Taking the middle number (using various bif's to get it) slapping a '0'
as a prefix and taking the right two characters.
- Year
reformatting it to 2008-06-05
converting it to a date
and passing it back.

Rob Berendt





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot 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 here. If you have questions about this, please contact