Re: Date Conversion

Hello,

the output is : Jul 25
my desired output is: 0725
[Quoted] [Quoted] this is because i have to load into a table in the format MMDD

thanks
pavi
Sybrand Bakker wrote:
> On 26 Jul 2006 11:16:23 -0700, "pawan_test" <sridhara007_at_gmail.com>
> wrote:
>
> >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 into YYYYMMDD
> >FORMAT.
> >
> > Thanks
> > pavi
>
> What has this do to with Oracle?
>
> --
> Sybrand Bakker, Senior Oracle DBA
Received on Wed Jul 26 2006 - 20:32:51 CEST