Skip site navigation (1) Skip section navigation (2)

pgsql: Fix date_trunct for December dates that are in the next year,

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix date_trunct for December dates that are in the next year,
Date: 2005-07-04 14:38:32
Message-ID: 20050704143832.65D1452923@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Fix date_trunct for December dates that are in the next year, e.g.:

        SELECT date_trunc('week', '2002-12-31'::date);

Backpatch to 8.0.X.

Per report from Nick Johnson.

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        timestamp.c (r1.128 -> r1.129)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c.diff?r1=1.128&r2=1.129)

pgsql-committers by date

Next:From: Bruce MomjianDate: 2005-07-04 14:42:40
Subject: pgsql: Backpatch to 8.0.X openssl portability fixes to pgcrypto.
Previous:From: Bruce MomjianDate: 2005-07-04 14:12:46
Subject: pgsql: Fix date_trunct for December dates that are in the next year,

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group