Re: "select" question
From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: Tue, 26 Dec 2000 13:12:13 -0800
Message-ID: <92b1ih$re8$1_at_spiney.sierra.com>
Date: Tue, 26 Dec 2000 13:12:13 -0800
Message-ID: <92b1ih$re8$1_at_spiney.sierra.com>
try:
select * from scheuler where s_gebdat =
TO_DATE('02-FEB-1967','DD-MON-YYYY');
if this fails, then your s_gebdat field is not a date field.
"Josef Zellner" <josef.zellner_at_aon.at> wrote in message
news:3A487A05.2F3F5F2F_at_aon.at...
> 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
>
Received on Tue Dec 26 2000 - 22:12:13 CET