Re: simple select statement problem
From: Álvaro G. Vicario <alvaro.NOSPAMTHANX_at_demogracia.com>
Date: Thu, 30 Apr 2009 17:20:28 +0200
Message-ID: <gtcfjs$rnr$2_at_news.eternal-september.org>
maunicar_at_gmail.com escribió:
>
> 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');
Date: Thu, 30 Apr 2009 17:20:28 +0200
Message-ID: <gtcfjs$rnr$2_at_news.eternal-september.org>
maunicar_at_gmail.com escribió:
>> 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');
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 --Received on Thu Apr 30 2009 - 10:20:28 CDT