date format not recognized
From: <muhammaddzulkarnain_at_gmail.com>
Date: Wed, 22 Oct 2008 22:10:41 -0700 (PDT)
Message-ID: <50b3bcfb-a667-4291-88ed-a66268683b30@u46g2000hsc.googlegroups.com>
Date: Wed, 22 Oct 2008 22:10:41 -0700 (PDT)
Message-ID: <50b3bcfb-a667-4291-88ed-a66268683b30@u46g2000hsc.googlegroups.com>
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:10:41 CDT