Re: case, nvl and datetime fields
From: bon <magicrat880_at_hotmail.com>
Date: 10 Dec 2003 04:47:31 -0800
Message-ID: <c7986eaf.0312100447.7e9dae36_at_posting.google.com>
Date: 10 Dec 2003 04:47:31 -0800
Message-ID: <c7986eaf.0312100447.7e9dae36_at_posting.google.com>
"VC" <boston103_at_hotmail.com> wrote in message news:<rqoBb.347574$ao4.1164423_at_attbi_s51>...
> Hello,
>
> DECODE(loandate, null, 'N', 'Y')
>
> ..or
>
> case when loandate is null then 'N' else 'Y' end
>
> Rgds.
>
Thanks
I actually did find out a way to do it eventually, but unlike you I
complicated it more than necessary...
(if you are good at reading between the lines, you probably realize
now my real problem was with conflicting data types in my original
attempt to translate it)
CASE nvl(loandate,to_date(NULL)) WHEN to_date(NULL) THEN 'N' ELSE 'Y' END Received on Wed Dec 10 2003 - 13:47:31 CET