[BUGS] IYYY: unexpected behaviour

Thu, 12 Oct 2006 09:44:27 -0700

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)"

Reply via email to