date format not recognized

#21

On Oct 23, 10:00*am, "Michel Cadot" <micadot{at}altern{dot}org> wrote:

Quote:

muhammaddzulkarn... (AT) gmail (DOT) com> a écrit dans le message de news:
e04ca099-0977-44b4-84f4-b662db8fa... (AT) y21g2000hsf (DOT) 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/uniont...1m23seals.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

date format not recognized

comp.databases.oracle.misc comp.databases.oracle.misc

Re: date format not recognized - 10-23-2008 , 05:22 PM