Обсуждение: Getting that starts a week of the year

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.

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