04-27-11, 12:12 #1Registered User
- Join Date
- Apr 2011
Unanswered: AS400: how to convert decimal to date or char format
I have a question regarding sql query in AS400
could you plz tell how to convert number (20071123) to char '20071123' then back to the date format '2007/11/23' (yyyy/mm/dd).
Thanks & Regards,