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