Decimal Value as a Date
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?
Thanks.
Software/Hardware used:
Software/Hardware used:
ASKED:
October 21, 2008 9:05 PM
UPDATED:
October 22, 2008 3:29 PM
RELATED QUESTIONS
- Getting a decimal data error when making a change in COBOL AS/400
- Explain diiferent data types in AS400
- Why do I have such a problem with passing to a program a 8 byte field using a parm.
- How to move an AS/400 numeric field to an alphanumeric field without disturbing the value in it?
- Arrays in AS/400
Answer Wiki:
If you are using RPG, try the %Date() BIF.
If you are using SQL, use the Cast or Date functions.
Gerardo
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
