Re: strange behavior of decode?

From: Mike Dwyer <dwyermj_at_co>
Date: 2000/08/11
Message-ID: <YrYk5.12$hr3.589@wdc-read-01.qwest.net>#1/1

Right-padding with spaces:

select decode( to_char( sysdate, 'Day'), 'Friday ',1, 2) from dual;

DECODE(TO_CHAR(SYSDATE,'DAY'),'FRIDAY',1,2)

---

                                          1

select length( to_char( sysdate, 'Day')) from dual;

LENGTH(TO_CHAR(SYSDATE,'DAY'))

---

                             9

"Maurice Samuels" <samuels_at_red.seas.upenn.edu> wrote in message news:8n1aoc$mnl$1_at_netnews.upenn.edu...
> can anyone explain to me why this does not work:
>
> select to_char(sysdate,'Day') from dual;
> output -> Friday
>
> select decode(to_char(sysdate,'Day'),'Friday',1,2) from dual;
> output -> 2
>
> why is the output not 1?
>
> if i do:
> select decode(to_char(sysdate,'Dy'),'Fri',1,2) from dual;
> output -> 1
>
> why does the decode work in this case but not the previous?
> any help would be much appreciated.
> -maurice
> samuels_at_seas.upenn.edu
Received on Fri Aug 11 2000 - 00:00:00 CDT