Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> How to tell if a date is NULL??

How to tell if a date is NULL??

From: Richard Hollingsworth <william.hollingsworth_at_hsv.boeing.com>
Date: Thu, 5 Oct 2000 17:32:35 GMT
Message-ID: <39DCBB33.6ACA4615@hsv.boeing.com>

Hi. Thanks for reading this.

I need to find out if a date is NULL in SQL. How do you do that?

My best try do far is

Select *******
  From ******
   Where SysDate - OtherDate != 0;

Is there a better way?

Thanks,
RIchard Hollingsworth Received on Thu Oct 05 2000 - 12:32:35 CDT

Original text of this message

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