X-Original-To: pgsql-general@postgresql.org
Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP
	id A178F475DBC; Fri,  7 Feb 2003 15:58:42 -0500 (EST)
Received: from ns.minardi.com.mx (ns.minardi.com.mx [148.223.125.238])
	by postgresql.org (Postfix) with ESMTP
	id 83C72475AA1; Fri,  7 Feb 2003 15:57:43 -0500 (EST)
Received: from heracles.santarita.intranet (heracles.santarita.intranet
	[192.168.1.105]) (authenticated (0 bits))
	by ns.minardi.com.mx (8.11.6/8.11.6/SuSE Linux 0.5) with ESMTP id
	h17Kvhn04104; Fri, 7 Feb 2003 14:57:43 -0600
Subject: Start and End Day of a Week
From: Luis =?ISO-8859-1?Q?Maga=F1a?= <joe666@gnovus.com>
Reply-To: joe666@gnovus.com
To: Postgresql General Mail List <pgsql-general@postgresql.org>,
	Postgresql SQL Mail List <pgsql-sql@postgresql.org>
Content-Type: text/plain; charset=ISO-8859-1
Organization: Gnovus Networks & Software
Message-Id: <1044651478.1124.3.camel@kerberus>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.2.1 
Date: 07 Feb 2003 14:57:58 -0600
X-Scanned-By: MIMEDefang 2.12 (www dot roaringpenguin dot com slash
 mimedefang)
Content-Transfer-Encoding: quoted-printable
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200302/522
X-Sequence-Number: 37276

Hi,=20

how can I get the first and last day of a week given the year and the
week number ???

example

week 3 of 2003 starts in Jan 12th and ends on Jan 18th.

how to know the last two values given the year and the number of week ?

thanks.

Best Regards.

--=20
Luis Maga=F1a.
Gnovus Networks & Software.
www.gnovus.com