Re: simple select statement problem

From: <maunicar_at_gmail.com>
Date: Thu, 30 Apr 2009 07:35:35 -0700 (PDT)
Message-ID: <1a3a6207-6f4e-4ece-bcbf-1740e6cf0149_at_d25g2000prn.googlegroups.com>

On Apr 30, 9:33 am, mauni..._at_gmail.com wrote:
> 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');

even I tried with
select io.accession,
to_char(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_date ('2009-01-04' , 'yyyy-dd-mm');
same error.
Thanks,
M. Received on Thu Apr 30 2009 - 09:35:35 CDT