if date_9 =20DEC1984 would like convert as 20-DEC-84 You may use date_format= substr(date_9,1,2)||'-'||substr(date_9,3,3)||'-'||substr(date_9,6,4) and use format Format date_format DDMMYYD9.
... View more
Hi Guniba, As per your earlier question from Anca's Code where aggregation is not given which is required but you said code is working. Have you added additional to Anca's code.Could you please let us know completely Thanks, Anusha
... View more