Re: problem with a trigger

From: BlackEagle <slimane_at_tsk.be>
Date: Fri, 12 Dec 2003 13:57:29 GMT
Message-ID: <dPjCb.74132$ev4.2994207_at_phobos.telenet-ops.be>


"Tiago Rocha" <tiagocrspamtalho_at_terra.com.br> schreef in bericht news:7mhjtvocc966qdrkosr98s7nasla6gjp6m_at_4ax.com...
> 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
>
> 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

I didn't call you a liar :)
at school they have also oracle 8.0
[Quoted] and there also sunday = 1 like you said. I think it depends on which db you use.
[Quoted] I'm using 9.0, it's just my opinion, I don't exactly know why.. [Quoted] but I still haven't got any help with my trigger. Frank? Tiago?
can't you help me out on this? Received on Fri Dec 12 2003 - 14:57:29 CET

Original text of this message