They aren't really the same time, that's just what you're displaying.
Use something like trunc(DATE_CREATED) or a to_char function if you only
want to see one row per day.

jAS

-----Original Message-----
From: (Frank Dodgers)
[mailto:oracledba-ezmlmshield-x17191326.[Email address protected]
Sent: Monday, November 29, 2004 11:34 AM
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


Oracle LazyDBA home page