IYYY: unexpected behaviour

From: "Zubkovsky, Sergey" <Sergey(dot)Zubkovsky(at)transas(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: IYYY: unexpected behaviour
Date: 2006-10-12 16:11:06
Message-ID: F5B7CF3F3C297B418A277AFC52CE7CF104C4FDA5@apt.transas.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

SELECT to_char( '2006-01-01'::timestamp, 'IYYY-MM-DD' ) AS strange,

to_char( '2006-01-02'::timestamp, 'IYYY-MM-DD' ),

to_char( '2006-01-01'::timestamp, 'YYYY-MM-DD' );

does produce unexpected result for column 'strange':

strange | to_char | to_char

------------+------------+------------

2005-01-01 | 2006-01-02 | 2006-01-01

(1 row)

Is this a bug?

select version();

"PostgreSQL 8.2beta1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)"

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Peter Eisentraut 2006-10-12 17:01:42 Re: IYYY: unexpected behaviour
Previous Message Peter Eisentraut 2006-10-12 14:53:05 Re: BUG #2688: Building from source with PL/Python fails ("distutils not found")