From: | Robert Creager <Robert_Creager(at)LogicalChaos(dot)org> |
---|---|
To: | "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #1094: date_part('week') bug |
Date: | 2004-03-05 03:46:19 |
Message-ID: | 20040304204619.4f8c446a.Robert_Creager@LogicalChaos.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
--Multipart_Thu__4_Mar_2004_20_46_19_-0700_=.xwOk6Er1v(HhYE
Content-Type: text/plain; charset=US-ASCII
Content-Disposition: inline
Content-Transfer-Encoding: 7bit
When grilled further on (Thu, 4 Mar 2004 13:56:42 -0400 (AST)),
"PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org> confessed:
> Some late dates give in some years wrong
> date_part('week')
>
> examples:
>
> select date_part('week', '2003-12-30'::date);
> date_part
> -----------
> 1
> (1 row)
If you read the documentation on the function date_part 'week', you'll
understand that this is the correct behavior, not a bug.
Later,
Rob
--
20:42:47 up 19 days, 4:20, 2 users, load average: 2.07, 2.14, 2.11
Linux 2.4.21-0.13_test #60 SMP Sun Dec 7 17:00:02 MST 2003
--Multipart_Thu__4_Mar_2004_20_46_19_-0700_=.xwOk6Er1v(HhYE
Content-Type: application/pgp-signature
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (GNU/Linux)
iEYEARECAAYFAkBH+BIACgkQLQ/DKuwDYzlWlgCdHZtPyGme1UDaNQa2cPa4IkoA
E04Aniq5VGab/H3PJx6dFtF8srM6CGhl
=tuD7
-----END PGP SIGNATURE-----
--Multipart_Thu__4_Mar_2004_20_46_19_-0700_=.xwOk6Er1v(HhYE--
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2004-03-05 19:47:33 | New Instance of Variable Not Found in Subplan Bug |
Previous Message | Bruno Wolff III | 2004-03-04 18:12:31 | Re: BUG #1094: date_part('week') bug |