I have an AS/400 field called ADMIT_DATE that is typed DECIMAL(8,0). It contains values such as 20061031. (including the decimal point). I would like to convert that field to an AS/400 DATE field such that the resulting values look like 2006-10-31. Can someone provide an example using the AS/400 type conversion functions?
October 21, 2008 9:05 PM
October 22, 2008 3:29 PM