Start and End Day of a Week

From: Luis Magaña <joe666(at)gnovus(dot)com>
To: Postgresql General Mail List <pgsql-general(at)postgresql(dot)org>, Postgresql SQL Mail List <pgsql-sql(at)postgresql(dot)org>
Subject: Start and End Day of a Week
Date: 2003-02-07 20:57:58
Message-ID: 1044651478.1124.3.camel@kerberus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Hi,

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.

--
Luis Magaña.
Gnovus Networks & Software.
www.gnovus.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eduardo 2003-02-07 20:58:59 DATABASE EXAMPLES?
Previous Message John Smith 2003-02-07 20:54:21 Re: selects with large offset really slow

Browse pgsql-sql by date

  From Date Subject
Next Message Eduardo 2003-02-07 20:58:59 DATABASE EXAMPLES?
Previous Message Ehmann, Mary 2003-02-07 19:00:35