Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: pgsql-general@xxxxxxxxxxxxxx
Subject: bug with >to_char('2007-12-31'::DATE, 'YYYYIW')<
From: Daniel Schuchardt <daniel_schuchardt@xxxxxx>
Date: Tue, 04 Dec 2007 20:07:50 +0100
Organization: Hub.Org Networking Services
User-agent: Thunderbird 2.0.0.9 (Windows/20071031)

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 5: don't forget to increase your free space map settings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: bug with >to_char('2007-12-31'::DATE, 'YYYYIW')<
  - From: Tom Lane
- Re: bug with >to_char('2007-12-31'::DATE, 'YYYYIW')<
  - From: Daniel Schuchardt

Prev by Date: Re: Recovering data via raw table and field separators
Next by Date: Re: bug with >to_char('2007-12-31'::DATE, 'YYYYIW')<
Previous by thread: Recovering data via raw table and field separators
Next by thread: Re: bug with >to_char('2007-12-31'::DATE, 'YYYYIW')<
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]

Powered by Linux