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');

On Apr 30, 9:33*am, mauni... (AT) gmail (DOT) com wrote:
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.

maunicar (AT) gmail (DOT) com escribió:
to_date(io.date_ordered, 'yyyy-mm-dd hh24:mi:ss')
to_char(io.date_ordered, 'yyyy-dd-mm hh24:mi:ss')

One of these must be wrong. What's "io.date_ordered", a DATE or a VARCHAR2?



--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--

maunicar (AT) gmail (DOT) com escribió:
Sorry, I hadn't noticed this other message.

You are doing TO_CHAR(...)>TO_DATE(...). Again, what data type is
"io.date_ordered"?


--
-- http://alvaro.es - Álvaro G. Vicario - Burgos, Spain
-- Mi sitio sobre programación web: http://borrame.com
-- Mi web de humor satinado: http://www.demogracia.com
--