Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!newsfeed.media.kyoto-u.ac.jp!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.icl.net!newsfeed.fjserv.net!skynet.be!213.51.129.3.MISMATCH!newshub1.home.nl!home.nl!not-for-mail From: Frank Newsgroups: comp.databases.oracle.tools Subject: Re: problem with a trigger Date: Fri, 12 Dec 2003 14:51:57 +0100 Organization: @Home Benelux Lines: 34 Message-ID: References: <%BvBb.69580$oC2.2788492@phobos.telenet-ops.be> <1de5ebe7.0312100514.7aef50ec@posting.google.com> <1071131818.828907@news.thyssen.com> <3djCb.74080$Pm4.2946156@phobos.telenet-ops.be> Reply-To: fbortel@nescape.net NNTP-Posting-Host: cc28855-a.hnglo1.ov.home.nl Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news4.tilbu1.nb.home.nl 1071236584 11920 217.121.193.81 (12 Dec 2003 13:43:04 GMT) X-Complaints-To: abuse@home.nl NNTP-Posting-Date: Fri, 12 Dec 2003 13:43:04 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en In-Reply-To: Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:83963 BlackEagle wrote: > "Tiago Rocha" schreef in bericht > news:cmgjtv4kg18kktj91uo8kk9b0bv87cb90p@4ax.com... > >>On Fri, 12 Dec 2003 13:16:47 GMT, "BlackEagle" 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 Bortel