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: SQL - Select and filtering whereby a date is not null.

Re: SQL - Select and filtering whereby a date is not null.

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: 23 Mar 2005 09:56:29 -0800
Message-ID: <1111600589.349998.228840@l41g2000cwc.googlegroups.com> 





Show us your workaround. It might have a clue in what's wrong.



FYI, I do not see S.Rel_End_Date in your query. There is no table alias
or table named "S" in the query you posted. How do you know it is
coming back with NULL?



Are you sure you are not missing some other join criteria?



What happens if you change Rel_End_Date IS NOT NULL;
to Rel_End_Date >to_date('1900-01-01','YYYY-MM-DD') ;
?



Ed.
Received on Wed Mar 23 2005 - 11:56:29 CST












Original text of this message













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