Message-ID: <3A487A05.2F3F5F2F@aon.at> Date: Tue, 26 Dec 2000 11:59:18 +0100 From: Josef Zellner X-Mailer: Mozilla 4.5 [de] (Win98; I) X-Accept-Language: de MIME-Version: 1.0 Newsgroups: comp.databases.oracle Subject: "select" question Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 11 NNTP-Posting-Host: 62.46.160.166 X-Trace: newsreader01.vienna.highway.telekom.at 977827591 17820 62.46.160.166 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