Re: "select" question

From: Lee Miller <>
Date: 27 Dec 2000 14:52:48 GMT
Message-ID: <> wrote:
> the system still gives me no results ('no rows selected')

Assuming s_gebdat has a datatype of date it is storing time and date. If you do a to_date the date you are looking for is defaulting to 12:00. Try the following:

select * from schueler where to_char(s_gebdat) = '02-FEB-67';

alternately you could trunc the date off to eliminate the time factor with:

select * from schueler where trunc(s_gebdat) = to_date('02-FEB-67');

you should receive the same results, unless you have dates from different centuries in your table (ie '1867', '1967', 2067') Received on Wed Dec 27 2000 - 15:52:48 CET

Original text of this message