Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!fu-berlin.de!uni-berlin.de!pj28.rce.neoline.com.BR!not-for-mail From: Tiago Rocha Newsgroups: comp.databases.oracle.tools Subject: Re: problem with a trigger Date: Fri, 12 Dec 2003 10:53:11 -0300 Lines: 25 Message-ID: <7mhjtvocc966qdrkosr98s7nasla6gjp6m@4ax.com> 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> NNTP-Posting-Host: pj28.rce.neoline.com.br (200.199.7.28) Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: news.uni-berlin.de 1071237042 2015758 200.199.7.28 ([131164]) X-Newsreader: Forte Free Agent 1.93/32.576 English (American) Xref: newssvr20.news.prodigy.com comp.databases.oracle.tools:83964 On Fri, 12 Dec 2003 13:37:23 GMT, "BlackEagle" wrote: > >not in my database :) >Howcome ? I don't know... but I've tested it several times... >sunday = 7 >saturday = 6 Well, so Oracle must have a setting somewhere to make sunday=7, but I'm just a developer, I'm not aware of such setting. In my DB (8.1.7.4.0), today (friday) is 6, saturday is 7 and sunday is 1: SQL> select sysdate, to_char(sysdate, 'd' ), 2 sysdate +1, to_char(sysdate + 1, 'd' ), 3 sysdate +2, to_char(sysdate + 2, 'd' ) 4 from dual; SYSDATE T SYSDATE+1 T SYSDATE+2 T --------- - --------- - --------- - 12-DEC-03 6 13-DEC-03 7 14-DEC-03 1 -- Tiago Rocha Recife - Brasil www.diariodastrilhas.cjb.net