Postgres Pro
Downloads
Home   >   mailing lists

Start and End Day of a Week - Mailing list pgsql-general

From Luis Magaña
Subject Start and End Day of a Week
Date
Msg-id 1044651478.1124.3.camel@kerberus
Whole thread Raw
Responses Re: [SQL] Start and End Day of a Week  (Luis Magaña <joe666@gnovus.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: John Smith
Date:
Subject: Re: selects with large offset really slow
Next
From: "scott.marlowe"
Date:
Subject: Re: corruption bug in 7.2.3-RH