============================================================================
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:
---------------------------------------------------------------------