Re: "select" question

Try the method Steve McDaniels suggested. That should work.

On Tue, 26 Dec 2000 17:23:56 -0700, Zatherus <zatherus_at_theriver.com> wrote:

>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 Thu Dec 28 2000 - 04:05:47 CET