Run this before you run the query :
alter session set NLS_DATE_FORMAT='dd-mon-yyyy hh24:mi:ss';
-----Original Message-----
From: Keith Williams
[mailto:oracledba-ezmlmshield-x69045232.[Email address protected]
Sent: Monday, November 29, 2004 10:44 AM
To: LazyDBA Discussion
Subject: RE: select distinct question
I would bet the dates are not identical and that the time portions are
different, but hidden by the format string.
-----Original Message-----
From: (Frank Dodgers)
[mailto:oracledba-ezmlmshield-x17191326.[Email address protected]
Sent: Monday, November 29, 2004 12:34 PM
To: LazyDBA Discussion
Subject: select distinct question
Anyone know why this select distinct returns multiple rows with the same
value? Thanks so much! (the "-" is actually an "@" for a dblink.
SQL> select distinct CLAIM_DRIVER_STEPS.DATE_CREATED from CLAIM_DRIVER_STEPS
where DATE_CREATED not in (select DATE_CREATED from
CLAIM_DRIVER_STEPS-cpedev);
DATE_CREA
---------
23-SEP-04
23-SEP-04
2 rows selected.
--
Thank You,
Frank Dodgers
Oracle & DB2 Certified
Evergreen Information Systems
-303-674-0433 Home
-303-810-6625 Cell
frank.[Email address protected]
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
"MMS <firstam.com>" made the following
annotations on 11/29/2004 10:55:09 AM
------------------------------------------------------------------------------
"THIS E-MAIL MESSAGE AND ANY FILES TRANSMITTED HEREWITH, ARE INTENDED SOLELY FOR THE USE OF THE INDIVIDUAL(S) ADDRESSED AND MAY CONTAIN CONFIDENTIAL, PROPRIETARY OR PRIVILEGED INFORMATION. IF YOU ARE NOT THE ADDRESSEE INDICATED IN THIS MESSAGE (OR RESPONSIBLE FOR DELIVERY OF THIS MESSAGE TO SUCH PERSON) YOU MAY NOT REVIEW, USE, DISCLOSE OR DISTRIBUTE THIS MESSAGE OR ANY FILES TRANSMITTED HEREWITH. IF YOU RECEIVE THIS MESSAGE IN ERROR, PLEASE CONTACT THE SENDER BY REPLY E-MAIL AND DELETE THIS MESSAGE AND ALL COPIES OF IT FROM YOUR SYSTEM."
==============================================================================
Oracle LazyDBA home page