Re: date format not recognized

On Oct 23, 10:00 am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <muhammaddzulkarn..._at_gmail.com> a écrit dans le message de news:
> e04ca099-0977-44b4-84f4-b662db8fa..._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

That link seems borked to me. But then again, I've seen some strange effects trying to go directly in to orafaq from my odd locations. Could you maybe give a string to search on or a subject?

jg

--
@home.com is bogus.
Protect the children!  No wait, save the seals!  No wait, states
rights!  No wait, one organism one vote, bacteria rule!
http://www.signonsandiego.com/uniontrib/20081023/news_1m23seals.html