Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: distinct doesn't work when I include date

Re: distinct doesn't work when I include date

From: sybrandb <sybrandb_at_gmail.com>
Date: 26 Jul 2006 08:01:16 -0700
Message-ID: <1153926075.553057.37530@m73g2000cwd.googlegroups.com> 






drd..._at_canoemail.com wrote:


> shoot I always forget this..

>

> Oracle 9i

>

> oracle client 9.2.7




Do you have a time stored in your date column?
Then this your very issue.


You'll need to TRUNC the date.


-- 
Sybrand Bakker
Senior Oracle DBA


Received on Wed Jul 26 2006 - 10:01:16 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US