Re: problem with a trigger
From: Frank <fbortel_at_nescape.net>
Date: Fri, 12 Dec 2003 14:51:57 +0100
Message-ID: <brcgl8$bkg$1_at_news4.tilbu1.nb.home.nl>
>
>
> not in my database :)
> Howcome ? I don't know... but I've tested it several times...
> sunday = 7
> saturday = 6
>
>
>
Date: Fri, 12 Dec 2003 14:51:57 +0100
Message-ID: <brcgl8$bkg$1_at_news4.tilbu1.nb.home.nl>
BlackEagle wrote:
> "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 :)
> Howcome ? I don't know... but I've tested it several times...
> sunday = 7
> saturday = 6
>
>
>
That's how it is - check the NLS part of your manual. The week does not start at the same day in every part of the world. So - you're both wrong, and right.
-- Regards, Frank van BortelReceived on Fri Dec 12 2003 - 14:51:57 CET