Path: news.easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!skynet.be!skynet.be!newscore.univie.ac.at!newsmaster-01.atnet.at!atnet.at!leech.it-austria.net!newsfeed01.univie.ac.at!murmel.gams.at!loopback!nobody From: Franz Zahaurek Newsgroups: comp.databases.oracle.tools Subject: Re: [REPOST] The "TO_DATE" Function Question Date: 01 Jan 2002 21:44:50 +0100 Organization: g.a.m.s. Lines: 20 Message-ID: References: NNTP-Posting-Host: 194.42.98.27 Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: murmel.gams.at 1009918007 22221 194.42.98.27 (1 Jan 2002 20:46:47 GMT) X-Complaints-To: usenet@murmel.gams.at NNTP-Posting-Date: 1 Jan 2002 20:46:47 GMT User-Agent: Gnus/5.0807 (Gnus v5.8.7) XEmacs/21.1 (Cuyahoga Valley) Xref: easynews comp.databases.oracle.tools:47427 X-Received-Date: Tue, 01 Jan 2002 18:18:38 MST (news.easynews.com) aleatory@hotmail.com (aleatory) writes: > [...] > | SQL> SELECT last_name, registration_date, > | 2 TO_CHAR ( registration_date, 'MM/DD/YYYY' ) > | 3 FROM student > | 4 WHERE registration_date = '22-JAN-99' > | 5 / > > After executing this, the program displays: > > | no rows selected The DATE datatype is able to store date and time with a resolution of seconds. So maybe you have to strip off the time part of registration_date with the trunc(date function) to get the result. -- Franz Zahaurek fzk@gams.at Vienna, Austria, Europe http://www.fzk.at