Re: problem with a trigger
From: BlackEagle <slimane_at_tsk.be>
Date: Fri, 12 Dec 2003 13:37:23 GMT
Message-ID: <nwjCb.74112$DX3.2935834_at_phobos.telenet-ops.be>
Date: Fri, 12 Dec 2003 13:37:23 GMT
Message-ID: <nwjCb.74112$DX3.2935834_at_phobos.telenet-ops.be>
[Quoted] "Tiago Rocha" <tiagocrspamtalho_at_terra.com.br> schreef in bericht
news:cmgjtv4kg18kktj91uo8kk9b0bv87cb90p_at_4ax.com...
> 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.net
not in my database :)
[Quoted] [Quoted] Howcome ? I don't know... but I've tested it several times...
sunday = 7
saturday = 6
Received on Fri Dec 12 2003 - 14:37:23 CET