date format not recognized
From: <muhammaddzulkarnain_at_gmail.com>
Date: Wed, 22 Oct 2008 22:09:02 -0700 (PDT)
Message-ID: <e04ca099-0977-44b4-84f4-b662db8fabee@y21g2000hsf.googlegroups.com>
Date: Wed, 22 Oct 2008 22:09:02 -0700 (PDT)
Message-ID: <e04ca099-0977-44b4-84f4-b662db8fabee@y21g2000hsf.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:09:02 CDT