Re: converting a specified year and week into a date - Mailing list pgsql-general

From Ron Johnson
Subject Re: converting a specified year and week into a date
Date
Msg-id 45D2D1F9.50006@cox.net
Whole thread Raw
In response to Re: converting a specified year and week into a date  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: converting a specified year and week into a date  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 02/14/07 02:52, A. Kretschmer wrote:
> am  Tue, dem 13.02.2007, um 13:56:15 -0800 mailte vanessa folgendes:
[snip]
>
> test=*# select get_week(2007,2);
>         get_week
> -------------------------
>  08-01-2007 - 14-01-2007
> (1 row)

Is that week #2?

If weeks start on Sunday (which is what they do in the US), then
week #2 would either start on 04-Jan or 11-Jan (depending on whether
the 01-Jan partial week is considered week #1 or week #0).

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFF0tH5S9HxQb37XmcRAkcwAJkBy2zGzsOoHQYMWpQyy/gWkFMrYwCgvSPh
62eczkEjSH9hf/CqCmHLBzQ=
=bhxF
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: converting a specified year and week into a date
Next
From: "A. Kretschmer"
Date:
Subject: Re: converting a specified year and week into a date