Re: "select" question

Everyone gave you the solution, but did not tell you why you are having the problem. We are in the year 2000 (or 2001 depending when you read this). Whan you enter '02-FEB-67', Oracle thinks you want 2067, not 1967, because it defaults to the current century unless you either extract the full 4-digit year using the other people's methods, or if you change the NLS date format in your systemn or session to dd-mon-rr from dd-mon-yy (see ALTER SYSTEM or ALTER SESSION).

"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 Thu Dec 28 2000 - 15:50:12 CET