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?