Postgres Pro
Downloads
Home   >   mailing lists

Thread: Getting that starts a week of the year

Getting that starts a week of the year

From
Wells Oliver
Date:
Is there a way to get the date that starts week 14, or 15 (etc)?

--
Wells Oliver
wellsoliver@gmail.com

Re: Getting that starts a week of the year

From
Thomas Kellerer
Date:
Wells Oliver, 22.04.2012 00:58:
> Is there a way to get the date that starts week 14, or 15 (etc)?

Try this:

select to_date('201214', 'iyyyiw')

That uses the ISO week definition.

Re: Getting that starts a week of the year

From
"Albe Laurenz"
Date:
Wells Oliver wrote:
> Is there a way to get the date that starts week 14, or 15 (etc)?

Which week numbering do you use?

http://en.wikipedia.org/wiki/Week_number#Week_numbering

Yours,
Laurenz Albe