Re: "select" question
From: Zatherus <zatherus_at_theriver.com>
Date: Tue, 26 Dec 2000 17:23:56 -0700
Message-ID: <1idi4tstpr99juvqu30c91jccr5s54pien_at_4ax.com>
Date: Tue, 26 Dec 2000 17:23:56 -0700
Message-ID: <1idi4tstpr99juvqu30c91jccr5s54pien_at_4ax.com>
On Tue, 26 Dec 2000 11:59:18 +0100, Josef Zellner
<josef.zellner_at_aon.at> wrote:
>Hi all!
>I have to work with an Oracle Database (Version 7.5).
>If I type:
>select * from schueler where s_gebdat='02-FEB-67';
>I get no result. But if I query with the command:
>select * from schueler;
>There is an entry with '02-FEB-67'.
>So why does Oracle does not give me the row with this specific date if I
>seek for it in this first way?
>TIA
I believe you need to specify TO_DATE on your where clause. Try:
select * from schueler where s_gebdat = to_date('02-FEB-67') ; Received on Wed Dec 27 2000 - 01:23:56 CET