Re: Statement returing True/False in decode() function
From: LKBrwn_DBA <member30625_at_dbforums.com>
Date: Wed, 13 Aug 2003 21:42:51 +0000
Message-ID: <3236438.1060810971_at_dbforums.com>
Date: Wed, 13 Aug 2003 21:42:51 +0000
Message-ID: <3236438.1060810971_at_dbforums.com>
Try this:
..
decode(sign(sysdate-event_start),-1,'N'
,decode(sign(event_end-sysdate),-1,'N','Y'))
..
also you can use:
..
case
when sysdate between event_start and event_end
then 'Y' else 'N'
end as date_flag
..
-- Posted via http://dbforums.comReceived on Wed Aug 13 2003 - 23:42:51 CEST