I'm curious, would you not also need the TRUNC statement here as well?
where DATE_CREATED not in
(select TRUNC(DATE_CREATED) from CLAIM_DRIVER_STEPS-cpedev);
Randy Netz
Oracle DBA
816-860-3921 (work)
816-686-1639 (cell)
-----Original Message-----
From: Gupta Pankaj (FIIS)
[mailto:oracledba-ezmlmshield-x62598095.[Email address protected]
Sent: Monday, November 29, 2004 12:50 PM
To: LazyDBA Discussion
Subject: RE: select distinct question
Try the following query with TRUNC.
TRUNC will remove the time stamp.
select distinct TRUNC(CLAIM_DRIVER_STEPS.DATE_CREATED) from
CLAIM_DRIVER_STEPS
where DATE_CREATED not in (select DATE_CREATED from
CLAIM_DRIVER_STEPS-cpedev);
Pankaj Gupta
-----Original Message-----
From: Chris Hagemaier
[mailto:oracledba-ezmlmshield-x58406546.[Email address protected]
Sent: Monday, November 29, 2004 1:39 PM
To: LazyDBA Discussion
Subject: RE: select distinct question
Expand the date out with to_char(). I bet the time portion differs.
-----Original Message-----
From: (Frank Dodgers)
[mailto:oracledba-ezmlmshield-x17191326.[Email address protected]
Sent: Monday, November 29, 2004 10: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
SQL> 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
--
This message has been scanned for viruses and dangerous content by
MailScanner, and is believed to be clean.
Douglas County, Oregon
www.co.douglas.or.us
--------
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
Oracle LazyDBA home page