Re: date format not recognized

muhammaddzulkarn..._at_gmail.com wrote:
> Peter Nilsson <ai..._at_acay.com.au> wrote:
> > muhammaddzulkarn..._at_gmail.com wrote:
> > > select hostname, to_char(to_date(&date_start ,
> > > 'YYYYMMDD' || to_date(&date_end, 'YYYYMMDD')), 'YYYY')
> > > from gen_api_performance_daily where statistics_date
> > > between to_date(&date_start, 'YYYYMMDD') and
> > > to_date(&date_end , 'YYYYMMDD')
> >
> > ...it's pretty obvious why you're getting the error...
> >
> >   to_char
> >   (
> >     to_date
> >     (
> >       &date_start,
> >       'YYYYMMDD' || to_date(&date_end, 'YYYYMMDD')
> >     ),
> >     'YYYY'
> >   )
> >
> > What do you think that || will produce?

>

'Combine' in what way? Please show some actual examples; what you start with and what you're hoping to produce.

> i do not know to do it

Well we're at an impass. You know the inputs and outputs but not how to do the implementation. I probably know the implementation but I don't have the inputs and outputs. ;)

--
Peter