REPOST: Re: [REPOST] The "TO_DATE" Function Question

aleatory_at_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_at_gams.at
Vienna, Austria, Europe                 http://www.fzk.at

========= WAS CANCELLED BY =======:
Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!newsfeed00.sul.t-online.de!t-online.de!newsfeed.freenet.de!news2.euro.net!uunet!sac.uu.net!lax.uu.net!news.navix.net!u.n.a.c.4.n.c.3.l.l.e.r
From: Franz Zahaurek <fzk_at_gams.at>
Newsgroups: news.admin.censorship,alt.test,comp.databases.oracle.tools
Subject: cmsg cancel <m0pu4tls1p.fsf_at_franz.athome>
Control: cancel <m0pu4tls1p.fsf_at_franz.athome>
Date: Wed, 2 Jan 2002 01:47:59 GMT
Organization: Navix Internet Subscribers
Lines: 2
Message-ID: <cancel.m0pu4tls1p.fsf_at_franz.athome>
NNTP-Posting-Host: 166.102.15.34
X-Trace: iac5.navix.net 1009947993 29203 166.102.15.34 (2 Jan 2002 05:06:33 GMT)
X-Complaints-To: abuse_at_navix.net
NNTP-Posting-Date: 2 Jan 2002 05:06:33 GMT
X-No-Archive: yes
Comment: Dude, where's my NewsAgent?
Xref: news.uni-stuttgart.de control:40286674

autocancel