Re: problem with a trigger
From: Tiago Rocha <tiagocrspamtalho_at_terra.com.br>
Date: Fri, 12 Dec 2003 10:33:35 -0300
Message-ID: <cmgjtv4kg18kktj91uo8kk9b0bv87cb90p_at_4ax.com>
Date: Fri, 12 Dec 2003 10:33:35 -0300
Message-ID: <cmgjtv4kg18kktj91uo8kk9b0bv87cb90p_at_4ax.com>
[Quoted] On Fri, 12 Dec 2003 13:16:47 GMT, "BlackEagle" <slimane_at_tsk.be> wrote:
> IF TO_NUMBER(TO_CHAR(to_date(res_date,'dd-mon-yyyy'),'d')) = 7
> THEN raise_application_error(-20000,'We are closed on sunday');
"7" is saturday
sunday is "1"
-- Tiago Rocha Recife - Brasil www.diariodastrilhas.cjb.netReceived on Fri Dec 12 2003 - 14:33:35 CET