| From: | Kurt Roeckx <Q(at)ping(dot)be> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: ISO year. |
| Date: | 2003-12-18 17:27:13 |
| Message-ID: | 20031218172713.GA14573@ping.be |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-patches |
On Thu, Dec 18, 2003 at 11:41:18AM -0500, Tom Lane wrote:
> Kurt Roeckx <Q(at)ping(dot)be> writes:
> > This patch allows you to use IYYYY as format specifier to get the
> > ISO year, the year correspondeing to the ISO week number (IW).
>
> The purpose of to_char() as I understand it is to be 100% Oracle
> compatible, not to invent new features at random. Is this duplicating
> some Oracle functionality that was left out?
I have no idea if this in Oracle or not. But it's something I
needed, and other people in the past asked about it too.
You could use the normal year instead of the iso year, but around
newyear this always gives problems.
Kurt
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2003-12-18 17:28:20 | Re: replace all with * in pg_hba.conf |
| Previous Message | Andrew Dunstan | 2003-12-18 17:14:59 | replace all with * in pg_hba.conf |