[ADMIN] Getting that starts a week of the year

2012-04-21 Thread Wells Oliver
Is there a way to get the date that starts week 14, or 15 (etc)? -- Wells Oliver wellsoli...@gmail.com

Re: [ADMIN] Getting that starts a week of the year

2012-04-23 Thread Thomas Kellerer
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. -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www

Re: [ADMIN] Getting that starts a week of the year

2012-04-23 Thread Albe Laurenz
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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscrip