Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting that starts a week of the year - Mailing list pgsql-admin

From Thomas Kellerer
Subject Re: Getting that starts a week of the year
Date
Msg-id jn30gp$fbc$1@dough.gmane.org
Whole thread Raw
In response to Getting that starts a week of the year  (Wells Oliver <wellsoliver@gmail.com>)
List pgsql-admin
Tree view 
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.

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: What is the role of pg_filenode.map ?
Next
From: "Albe Laurenz"
Date:
Subject: Re: Getting that starts a week of the year