Hi All,

i have a directory such as;

find /home/pavi/ctl/INFOSCAN.KKK.*.*.ctl* -exec ls -ltr {} \; | awk -F" " {'print $6 " " $7'}

the output is : Jul 25

can anyone please suggest me how do I convert the above Date into YYYYMMDD FORMAT.

Thanks
pavi

which database is this for?

So you'd like to convert "Jul 25" into "YYYY0725"? Where's YYYY in "Jul 25"?