Re: Strange behavior with to_char and dates - Mailing list pgsql-bugs

From Heikki Linnakangas
Subject Re: Strange behavior with to_char and dates
Date
Msg-id 4967635E.1000306@enterprisedb.com
Whole thread Raw
In response to Strange behavior with to_char and dates  ("Denis Percevault" <d.percevault@pnsconcept.fr>)
List pgsql-bugs
Denis Percevault wrote:
> As you can see below,
> the request "to_char((current_date - 11), 'DD MM IYYY')" gives "29 12 2009" instead of "29 12 2008". With 12 or with
8the result is 
> good.

What you want is 'YYYY' instead of 'IYYY'. 'IYYY' is intended to be used
together with 'IW' and 'ID', to give a so-called "ISO week date". See
manual for more information, particularly this note:

> Attempting to construct a date using a mixture of ISO week and Gregorian date fields is nonsensical, and could yield
unexpectedresults. In the context of an ISO year, the concept of a 'month' or 'day of month' has no meaning. In the
contextof a Gregorian year, the ISO week has no meaning. Users should take care to keep Gregorian and ISO date
specificationsseparate.  

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

pgsql-bugs by date:

Previous
From: "Denis Percevault"
Date:
Subject: Strange behavior with to_char and dates
Next
From: "David Slayter"
Date:
Subject: BUG #4608: postgresql.conf and other .conf not created