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

pgsql: Fix wrong week returnded by date_trunc('week') for early dates in

From: momjian(at)svr1(dot)postgresql(dot)org (Bruce Momjian)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Fix wrong week returnded by date_trunc('week') for early dates in
Date: 2005-04-01 14:25:39
Message-ID: 20050401142539.DBB015345F@svr1.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Fix wrong week returnded by date_trunc('week') for early dates in
January --- would return wrong year for 2005-01-01 and 2006-01-01.

per report from Robert Creager.

Backpatch to 8.0.X.

Tags:
----
REL8_0_STABLE

Modified Files:
--------------
    pgsql/doc/src/sgml:
        func.sgml (r1.234.4.4 -> r1.234.4.5)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.234.4.4&r2=1.234.4.5)
    pgsql/src/backend/utils/adt:
        timestamp.c (r1.117 -> r1.117.4.1)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c.diff?r1=1.117&r2=1.117.4.1)

pgsql-committers by date

Next:From: Bruce MomjianDate: 2005-04-01 16:34:31
Subject: pgsql: Update pgcvslog examples.
Previous:From: Bruce MomjianDate: 2005-04-01 14:25:23
Subject: pgsql: Fix wrong week returnded by date_trunc('week') for early dates in

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