Re: Re: Week number

>>>>> "Peter" == Peter Eisentraut <peter_e(at)gmx(dot)net> writes:

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
roland(at)rlenter(dot)com 76-15 113th Street, Apt 3B
rbroberts(at)acm(dot)org Forest Hills, NY 11375