Re: "select" question
Date: Wed, 27 Dec 2000 10:43:24 -0500
Message-ID: <92d2mu$97m1_at_biko.telecom.ups.com>
The following query must work:
select * from schueler where trunc(s_gebdat) = '02-FEB-67'
s_gebdat may have time value also (HH:MI:SS) and that's why it is not a exact match. TRUNC(s_gebdat) will truncate the time and match with the date value alone.
If you want to see the time try the following. select to_char(s_gebdat,'DD-MON-YY HH:MI:SS') from schueler where trunc(s_gebdat) = '02-FEB-67'
Thanks
Pushparaj
Josef Zellner wrote in message <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 Wed Dec 27 2000 - 16:43:24 CET