Re: Sunday always day 1 of week ?

From: Rob Edgar <robedgar_at_mersey.com.hk>
Date: Sat, 25 Jul 1998 16:12:38 +0800
Message-ID: <6pc4ep$ldn3@news.hk.linkage.net>

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
> --------------------------------------------------------------------
Received on Sat Jul 25 1998 - 03:12:38 CDT