Using IBM i? Need to create Excel, CSV, HTML, JSON, PDF, SPOOL reports? Learn more about the fastest and least expensive tool for the job: SQL iQuery.
Is there any way we can convert a character field having Date '120511'(6A) to 20120511(8P 0)
You mean by adding the century and making it numeric? Or by going though a proper date routine?
While the former is rather trivial, I think you'll find what you need on the latter option on the links below.
And then there's the API way to go too, see link below.
Google's your friend...
Might want a MONITOR around it, but how about %DEC(%DATE('120511':*MDY0):*ISO)?
Actually I think the character date is *YMD0 format, but Dale is correct on the rest.