Re: problem with a trigger

[Quoted] On Fri, 12 Dec 2003 13:37:23 GMT, "BlackEagle" <slimane_at_tsk.be> wrote:

>
>not in my database :)
>Howcome ? I don't know... but I've tested it several times...
>sunday = 7
>saturday = 6

[Quoted] Well, so Oracle must have a setting somewhere to make sunday=7, but [Quoted] 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' )

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