simple select statement problem

From: <maunicar_at_gmail.com>
Date: Thu, 30 Apr 2009 07:33:28 -0700 (PDT)
Message-ID: <0d551bef-3541-49e8-be0f-1956866993c2_at_z23g2000prd.googlegroups.com>



Hi M/S:

Here I am selecting simple statement but I am getting ora01722 error. Can somebory please help me on this.
Thanks in advance.
Manchi.

select io.accession,
to_date(io.date_ordered, 'yyyy-mm-dd hh24:mi:ss') ACCESSION_KEY from instrument_orders io
where to_char(io.date_ordered, 'yyyy-dd-mm hh24:mi:ss') > to_char ('2009-01-04' , 'yyyy-dd-mm'); Received on Thu Apr 30 2009 - 09:33:28 CDT

Original text of this message