Re: DAYOFWEEK Function

"Harald Maier" <maierh_at_myself.com> wrote in message news:m3ad7rkj4k.fsf_at_ate.maierh...
>
> "Paul Dixon" <root_at_127.0.0.1> writes:
>
> > Alister,
> >
> > If you do use the to_char(date_value,'D') functionality as suggested
> > by Mark, you need to be aware that the value it returns is affected
> > by the NLS settings of the session that's executing the code (
> > something the Oracle documentation doesn't mention) e.g. Thursday is
> > day 4 for nls_territory 'UNITED KINGDOM' and day 5 for 'AMERICA'.
>
> That is not quite correct. From the 'Globalization Support Guide'
> (a96529-01) document at 3-26:
>
> ,----
> | First Day of the Week
> |
> | Some cultures consider Sunday to be the first day of the week. Others
> | consider Monday to be the first day of the week. A German calendar
> | starts with Monday, as shown in Table 3?5.
> |
> | The first day of the week is determined by the NLS_TERRITORY
> | parameter.

Harald,

I must admit I hadn't seen this (mainly because I first encountered the problem in Oracle 8i and I definitely couldn't find mention of this in the 8.1.7 documentation).

Shame the 9i documentation doesn't go on to detail which is the first day of the week for each NLS_TERRITORY value though.

Paul Dixon Received on Fri Oct 24 2003 - 06:51:03 CDT