From: | "A(dot) Kretschmer" <akretschmer(at)despammed(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: date_trunc('week', '2005-01-01'::TIMESTAMP) |
Date: | 2005-09-22 10:20:58 |
Message-ID: | 20050922102057.GA12957@webserv.wug-glas.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
am 22.09.2005, um 12:40:00 +0300 mailte pgsql-general(at)list(dot)coretech(dot)ro folgendes:
>
> select date_trunc('week', '2005-01-01'::TIMESTAMP) returns '2006-01-02
> 00:00:00'
Which version?
test=# select date_trunc('week', '2005-01-01'::TIMESTAMP);
date_trunc
---------------------
2004-12-27 00:00:00
(1 row)
test=# select version();
version
-------------------------------------------------------------------------------------------
PostgreSQL 8.0.3 on i386-pc-linux-gnu, compiled by GCC cc (GCC) 3.3.5 (Debian 1:3.3.5-13)
(1 row)
The result is IMHO correct.
Regards, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-09-22 12:23:12 | Re: Problem with libpq3 & postgresql8 |
Previous Message | Stas Oskin | 2005-09-22 10:01:40 | Re: Postgres locks table schema? |