bug-report

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

Your name : Eivind Kvedalen
Your email address : eivindkv(at)ifi(dot)uio(dot)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:
---------------------------------------------------------------------