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:23
Message-ID: 20050401142523.2E52453494@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.

Modified Files:
--------------
    pgsql/doc/src/sgml:
        func.sgml (r1.243 -> r1.244)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml.diff?r1=1.243&r2=1.244)
    pgsql/src/backend/utils/adt:
        timestamp.c (r1.117 -> r1.118)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/timestamp.c.diff?r1=1.117&r2=1.118)

pgsql-committers by date

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

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