Re: date format not recognized
From: Peter Nilsson <airia_at_acay.com.au>
Date: Wed, 22 Oct 2008 22:49:10 -0700 (PDT)
Message-ID: <b2d9fa07-b94a-4ffa-afab-db9866d550c3@d36g2000prf.googlegroups.com>
'YYYY'
)
Date: Wed, 22 Oct 2008 22:49:10 -0700 (PDT)
Message-ID: <b2d9fa07-b94a-4ffa-afab-db9866d550c3@d36g2000prf.googlegroups.com>
muhammaddzulkarn..._at_gmail.com wrote:
> hello everyone,
>
> i just got a problem. This is my statement:
>
> 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')
>
> when i executed the script, i got date format not
> recognized error. how to solve it?
Solve it? Who knows! But 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?
-- PeterReceived on Thu Oct 23 2008 - 00:49:10 CDT