Hi All,

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,
Venkatesh Gubba
gubba.venkatesh@gmail.com