pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedGetting that starts a week of the year
3+ messages / 3 participants
[nested] [flat]
* Getting that starts a week of the year
@ 2012-04-21 22:58 Wells Oliver <wellsoliver@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Wells Oliver @ 2012-04-21 22:58 UTC (permalink / raw)
To: pgsql-admin
Is there a way to get the date that starts week 14, or 15 (etc)?
--
Wells Oliver
wellsoliver@gmail.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Getting that starts a week of the year
@ 2012-04-23 07:33 Thomas Kellerer <spam_eater@gmx.net>
parent: Wells Oliver <wellsoliver@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Thomas Kellerer @ 2012-04-23 07:33 UTC (permalink / raw)
To: pgsql-admin
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Getting that starts a week of the year
@ 2012-04-23 07:39 Albe Laurenz <laurenz.albe@wien.gv.at>
parent: Wells Oliver <wellsoliver@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Albe Laurenz @ 2012-04-23 07:39 UTC (permalink / raw)
To: Wells Oliver *EXTERN* <wellsoliver@gmail.com>; pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-04-23 07:39 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-04-21 22:58 Getting that starts a week of the year Wells Oliver <wellsoliver@gmail.com>
2012-04-23 07:33 ` Thomas Kellerer <spam_eater@gmx.net>
2012-04-23 07:39 ` Albe Laurenz <laurenz.albe@wien.gv.at>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox