Hi,

While writing some pl/sql I have noticed my dates don't compare the same in the where clause vs. using decode. Executing from sqlplus.

Simple select on date coumn.
select rslt_dt from table;
RSLT_DT
---------
01-JAN-01

In the where clause I have to compare the date like this:
AND rd.rslt_dt <> '01-Jan-0001'

In the decode, I have to use this one:
DECODE(rd.rslt_dt, '01-JAN-01', ri.actl_dt, rd.rslt_dt) as rslt_dt,

What gives here. How can this be different?

Thanks,
Kathy