I have to write a query to fetch data. But one of the input date values is in julian format - YYDDD. I have to convert into DB2 compatible form CCYY/MM/DD. Is there any function available in DB2 to do that.
Input value is in a host variable. Writing a logic to convert using cobol would take long time.