Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Sunday always day 1 of week ?
Sunday is not always first day of the week. Numbering is based on
NLS_TERRIRORY parameter. Therefore, for some countries it is Sunday and for
some Monday and who knows maybe some contries count from Wednesday or Friday
(just a joke).
Solomon Yakobson.
In article <6pc4ep$ldn3_at_news.hk.linkage.net>,
"Rob Edgar" <robedgar_at_mersey.com.hk> wrote:
> I think this is the ISO standard
>
> Rob
>
> FORMULA_FO_at_NoSPAM-1751.yahoo.com wrote in message
> <6p4uar$e40$1_at_orthanc.reference.com>...
> >Date-format "D" returns "Day of week". Example:
> >
> >SELECT TO_CHAR(SYSDATE,'D') FROM DUAL;
> >returns a number in the range 1-7
> >
> >ORACLE documentation does not say anything about
> >which day is considered first day of week.
> >A test on our system shows that SUNDAY is considered
> >day 1 by ORACLE. Is it always so?
> >I know that in USA Sunday is first day of week,
> >but here (in Norway) Monday is.
> >Any national settings available?
> >Any ISO-standard on this?
> >
> >We use ORACLE 7.2.3 and PL/SQL + PRO*Cobol on a AIX 4.1.4
> >platform.
> >
> >Thanks!
> >Erik
> >
> >
> >
> > --------------------------------------------------------------------
> > Posted using Reference.COM http://WWW.Reference.COM
> > FREE Usenet and Mailing list archive, directory and clipping service
> > --------------------------------------------------------------------
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Sat Jul 25 1998 - 09:43:12 CDT