Re: converting a specified year and week into a date

am  Wed, dem 14.02.2007, um 11:53:09 +0100 mailte Alban Hertroys folgendes:
> vanessa wrote:
> > hi guys,
> > i was just wondering if it was at all possible to turn a year and a given
> > week number into a real date just using postgresql commands?
> >
> >
> > e.g. if i have year = 2004 and week = 1,
> >     can i turn that into say 2004-01-01 (so that the specified
> >     date is the one for the beginning of week 1 in the year 2004
> >
> >
> > thanks
> > vanessa  :)
>
> I think you're looking for this:
>
> select to_date('01 2004', 'WW YYYY');
>   to_date
> ------------
>  2004-01-01
> (1 row)

cool ;-)


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net