date format not recognized

From: <>
Date: Wed, 22 Oct 2008 22:09:02 -0700 (PDT)
Message-ID: <>

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? Received on Thu Oct 23 2008 - 00:09:02 CDT

Original text of this message