You can, but you will only by matching on the Day Month Year. Gupta is saying match on the exact Day Month Year HH Min SS, and only display the unique Day Month Year hits. It all depends on what you are trying to solve.
________________________________
From: Netz Randy N [mailto:oracledba-ezmlmshield-x73490879.[Email address protected]
Sent: Mon 11/29/2004 1:52 PM
To: LazyDBA Discussion
Subject: RE: select distinct question
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
--------
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