bug-report

============================================================================
                        POSTGRESQL BUG REPORT
============================================================================


Your name        : Eivind Kvedalen
Your email address    : eivindkv@ifi.uio.no


System Configuration
---------------------
  Architecture (example: Intel Pentium)      : Intel Pentium III

  Operating System (example: Linux 2.0.26 ELF)     :
    Linux support 2.2.14 #9 SMP Thu Oct 12 12:10:07 CEST 2000 i686 unknown


  PostgreSQL version (example: PostgreSQL-7.0):   PostgreSQL-7.0.2

  Compiler used (example:  gcc 2.8.0)        : egcs-2.91.66


Please enter a FULL description of your problem:
------------------------------------------------

to_char gives incorrect day conversion of the date 2000/03/26.


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

The SQL-code

create table test_table (
    date_col date
);

insert into test_table values ('2000/03/25');
insert into test_table values ('2000/03/26');

select date_col from test_table;
select to_char(date_col, 'YYYY/MM/DD - WW') from test_table;

drop table test_tab

results in

CREATE
INSERT 2370569 1
INSERT 2370570 1
  date_col
------------
 2000-03-25
 2000-03-26
(2 rows)

     to_char
-----------------
 2000/03/25 - 12
 2000/03/25 - 12
(2 rows)

which is incorrect. I have not detected any other dates which gives
the same result.

If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------