Re: Re: Week number - Mailing list pgsql-hackers

From Roland Roberts
Subject Re: Re: Week number
Date
Msg-id m24rwwgpy7.fsf@tycho.rlent.pnet
Whole thread Raw
In response to Re: Re: Week number  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
>>>>> "Peter" == Peter Eisentraut <peter_e@gmx.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@rlenter.com                     76-15 113th Street, Apt 3B
rbroberts@acm.org                          Forest Hills, NY 11375


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pgmonitor patch for query string
Next
From: Bruce Momjian
Date:
Subject: Re: pgmonitor patch for query string