Postgres Pro
Downloads
Home   >   mailing lists

How can I get the first and last date of a week, based on the week number and the year - Mailing list pgsql-general

From Bruno Baguette
Subject How can I get the first and last date of a week, based on the week number and the year
Date
Msg-id 47C4BDC1.2030902@gmail.com
Whole thread Raw
Responses Re: How can I get the first and last date of a week, based on the week number and the year
Re: How can I get the first and last date of a week, based on the week number and the year
Re: How can I get the first and last date of a week, based on the week number and the year
Re: How can I get the first and last date of a week, based on the week number and the year
List pgsql-general
Tree view 
Hello !

I have a week number (ISO 8601) and a year, based on theses values, I
would like to get the first and the last dates of that week.

How I can do that ?

The only solution is doing a big generate_series to build a subset that
contains the week of all the dates between the 01/01 || year and the
31/12 || year. But I find that solution quite dirty and ressources
consumming.

Is there a cleanest way to do that ?

Many thanks in advance !

Regards,

--
Bruno Baguette - bruno.baguette@gmail.com

pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: bug in 8.3? foreign key refers to different type
Next
From: Adrian Klaver
Date:
Subject: Re: How can I get the first and last date of a week, based on the week number and the year