[HACKERS] Re: Week number
Jim Mercer
> Jim Mercer writes:
> > most western calendars that i have seen show "Sun Mon Tue Wed Thu Fri Sat".
>
> Most *English* calendars you have seen, I suppose. In Germany there is no
> such possible calendar. If you printed a calendar that way, it would be
> considered a printo. The same is true in most parts of the continent.
i stand corrected. i haven't had much dealings with european business.
--
[ Jim Mercer j...@pneumonoultramicroscopicsilicovolcanoconiosis.ca ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ aka j...@reptiles.org +1 416 410-5633 ]
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Peter Eisentraut
> most western calendars that i have seen show "Sun Mon Tue Wed Thu Fri Sat".
Most *English* calendars you have seen, I suppose. In Germany there is no
such possible calendar. If you printed a calendar that way, it would be
considered a printo. The same is true in most parts of the continent.
The POSIX numbering (0-6) is actually pretty slick because it allows both
versions to work: In the U.S. (e.g.) you get a natural order starting at
0, in Germany (e.g.) you get Monday as #1.
> so, suffice to say, there is no "proper" first day of the week.
There is a proper ISO first day of the week. In many parts of Europe, the
day of the week + week of the year are real, official concepts. E.g., you
would mark business transactions as "week x, day y" instead of with a date
(notice how this simplifies arithmetic). Without trying to push through
my cultural bias, I think these applications should have some priority
over making up a solution that satisfies everybody but doesn't actually
suit any real application.
--
Peter Eisentraut pet...@gmx.net http://yi.org/peter-e/
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majo...@postgresql.org
Roland Roberts
Peter> The POSIX numbering (0-6) is actually pretty slick because
Peter> it allows both versions to work: In the U.S. (e.g.) you get
Peter> a natural order starting at 0, in Germany (e.g.) you get
Peter> Monday as #1.
Oracle's to_char() supports format IW for the ISO week of the year,
but there is no equivalent ID for the ISO day of the week. Perhaps
this should be a PostgreSQL extension?
roland
--
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD RL Enterprises
rol...@rlenter.com 76-15 113th Street, Apt 3B
rbro...@acm.org Forest Hills, NY 11375
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majo...@postgresql.org)
Roland Roberts
>> Unix day-of-week starts on Sunday, not Monday, which is what
>> date_trunc('dow',...) returns. Presumably this is modeled on
>> the traditional notion (at least in the US; I suspect this is
>> true in most European countries at least) of Sunday being "the
>> first day of week".
AZ> Germany and Austria have Monday as first day of week, I think
AZ> most of Europe also.
I believe the goal was to have a to_char() that was complete and
Oracle-compatible. Perhaps we need to also have a trunc() which is
Oracle compatible. I haven't been playing with 7.1beta, but 7.0
trunc() doesn't like timestamps. In Oracle, I can say
select trunc(sysdate) - trunc(sysdate,'ww') + 1 from dual;
to get Monday=1.
roland
--
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD RL Enterprises
rol...@rlenter.com 76-15 113th Street, Apt 3B
rbro...@acm.org Forest Hills, NY 11375
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
Karel Zak
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
On Wed, Mar 14, 2001 at 01:23:30PM -0500, Roland Roberts wrote:
> >>>>> "AZ" =3D=3D Zeugswetter Andreas SB <Zeugsw...@wien.spardat.at> w=
rites:
>=20
> >> Unix day-of-week starts on Sunday, not Monday, which is what
> >> date_trunc('dow',...) returns. Presumably this is modeled on
> >> the traditional notion (at least in the US; I suspect this is
> >> true in most European countries at least) of Sunday being "the
> >> first day of week".
>=20
> AZ> Germany and Austria have Monday as first day of week, I think
> AZ> most of Europe also.
>=20
> I believe the goal was to have a to_char() that was complete and
> Oracle-compatible. Perhaps we need to also have a trunc() which is
Yes, an Oracle-compatiblity is important for masks (format pictures)
used in both (Ora and PG). But our PG's implementation has some extensions,
for example 'ID' ISO-day-of-week in 7.2 where Monday =3D first day of week.
I hope all countries will glad :-)
for 'WW' and 'D' are results same:
Ora:
SVRMGR> select to_char( to_date('2001/03/12', 'YYYY/MM/DD'), 'WW Day D
YYYY/MM/DD') from dual;
TO_CHAR(TO_DATE('2001/03/
-------------------------
11 Monday 2 2001/03/12
1 row selected.
PG:
select to_char( to_date('2001/03/12', 'YYYY/MM/DD'), 'WW Day D YYYY/MM/DD');
to_char
---------------------------
11 Monday 2 2001/03/12
(1 row)
Karel
--=20
Karel Zak <za...@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
=20
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
--Nq2Wo0NMKNjxTN9z
Content-Type: application/pgp-signature
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 5.0i for non-commercial use
MessageID: GIUa3H66jmjBUmFCMLge74cCOJL58xJ2
iQCVAwUBOrCSMQllYRn8cE3VAQGCOwQAiyRgHJb6rcihdy0CelRI37cUPwFq3WIV
cuGvukC4Ef1zGREwv/TWwL0jbXGdcVfomR7z8GqXx93y7hvfNuorlQ5ZTCZziuRu
ZcPPOHlpkDVyak9z4PXOPhMDfbgpWUW7rMzBCQxGtqUV9oQXywm5CQ7SlE/QwOpC
uBw2fImeuyk=
=7oMe
-----END PGP SIGNATURE-----
--Nq2Wo0NMKNjxTN9z
Content-Type: text/plain
Content-Disposition: inline
Content-Transfer-Encoding: binary
MIME-Version: 1.0
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majo...@postgresql.org)
--Nq2Wo0NMKNjxTN9z--