Re: date format not recognized
From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 23 Oct 2008 19:00:16 +0200
Message-ID: <4900ada0$0$31532$426a34cc@news.free.fr>
Date: Thu, 23 Oct 2008 19:00:16 +0200
Message-ID: <4900ada0$0$31532$426a34cc@news.free.fr>
<muhammaddzulkarnain_at_gmail.com> a écrit dans le message de news:
e04ca099-0977-44b4-84f4-b662db8fabee_at_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?
See answers to your question at:
http://www.orafaq.com/forum/t/126566/102589/
Regards
Michel
Received on Thu Oct 23 2008 - 12:00:16 CDT