Re: "select" question

the system still gives me no results ('no rows selected')

Zatherus schrieb:

> 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 - 10:53:07 CET