Re: Date Conversion

pawan_test wrote:
> Hello,
>
> the output is : Jul 25
> my desired output is: 0725
> 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

1. Please refrain from top-posting.
2. The question stands: what have find, awk or ls to do with Oracle? find and awk are external programs not written nor distributed by Oracle Corp. ls is an OS command. Oh, you need to "load in a table"... How exactly are you going about loading? I mean - you got your output, suppose it's in desired format - and what will you do with it? How Oracle comes into play?

Regards,

    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)     http://www.dynamicpsp.com Received on Wed Jul 26 2006 - 21:57:34 CEST