Re: ISO year. - Mailing list pgsql-patches

From Kurt Roeckx
Subject Re: ISO year.
Date
Msg-id 20031218172713.GA14573@ping.be
Whole thread Raw
In response to Re: ISO year.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: ISO year.
List pgsql-patches
On Thu, Dec 18, 2003 at 11:41:18AM -0500, Tom Lane wrote:
> Kurt Roeckx <Q@ping.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


pgsql-patches by date:

Previous
From: Tom Lane
Date:
Subject: Re: ISO year.
Next
From: Peter Eisentraut
Date:
Subject: Re: ISO year.