Re: bug with >to_char('2007-12-31'::DATE, 'YYYYIW')<

Daniel Schuchardt <daniel_schuchardt@xxxxxx> · Tue, 04 Dec 2007 20:15:30 +0100

BTW:

Windows 2003 Server.

LOLL2=# SELECT version();

                                      version
--------------------------------------------------------------------------------
PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 
3.4.2 (mingw-special)
(1 row)

Regards :)

Daniel Schuchardt schrieb:
LOLL2=# SELECT  to_char('2007-12-31'::DATE, 'YYYYIW');
to_char
---------
200701
(1 row)

2007-12-31 should be week 2008-01

regards,

   Daniel.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
      choose an index scan if your joining column's datatypes do not
      match