Re: Null date

Wei,
  NULL can only be compared with the operators     IS or IS NOT

 so ...

   tempdate IS NULL

 would give your result.

 NULL with any other operator is ALWAYS false.

Regards
Dante

In article <7hcrdu$1h6$1_at_eipipeline.ei.org>,   wweng_at_ei.org wrote:
> is a date variable comparable to null?
>
> I mean if i have a table temp
> with
>
> tempid number constraint pk_tempid primary key;
> tempdate date;
>
> and I did
>
> insert temp (tempid) values (1);
>
> and then I do
>
> select tempdate into p from temp where tempid = 1;
>
> obviously, tempdate should be a null.
>
> So, can I do
>
> if tempdate = null then
> htp.p('it is null!');
> end if;
>
> or should I compare the tempdate to some other stuff so that
> I can tell it is empty?
>
> Thanks in advance
>
> wei
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 12 1999 - 18:05:17 CDT