Re: converting a specified year and week into a date

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Alban Hertroys <alban(at)magproductions(dot)nl>, vanessa <vanessaknell(at)gmail(dot)com>
Subject: Re: converting a specified year and week into a date
Date: 2007-02-14 11:31:50
Message-ID: 200702141231.51132.peter_e@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am Mittwoch, 14. Februar 2007 11:53 schrieb Alban Hertroys:
> I think you're looking for this:
>
> select to_date('01 2004', 'WW YYYY');
> to_date
> ------------
> 2004-01-01
> (1 row)

Or possibly to_date('01 2004', 'IW IYYY'), depending on taste.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raymond O'Donnell 2007-02-14 11:35:55 Re: help and Links using postgreSQL with ASP
Previous Message A. Kretschmer 2007-02-14 11:00:30 Re: converting a specified year and week into a date