Re: How to tell if a date is NULL??

From: Walter T Rejuney <BlueSax_at_Unforgetable.com>
Date: Fri, 06 Oct 2000 20:58:47 -0400
Message-ID: <39DE7546.59738FBC@Unforgetable.com>

Richard Hollingsworth wrote:

> 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;

SELECT *
FROM MYTABLE
WHERE TRUNC(TO_NUMBER(TO_CHAR(SYSDATE,'SSSSS'))) - TRUNC(NVL(TO_NUMBER(TO_CHAR(OTHERDATE,'SSSSS')), TO_NUMBER(TO_CHAR(SYSDATE,'SSSSS')))) != 0 Received on Fri Oct 06 2000 - 19:58:47 CDT