Re: DAYOFWEEK Function

From: Harald Maier <maierh_at_myself.com>
Date: Thu, 23 Oct 2003 18:34:51 +0200
Message-ID: <m3ad7rkj4k.fsf@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 Received on Thu Oct 23 2003 - 11:34:51 CDT