From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: converting a specified year and week into a date |
Date: | 2007-02-14 08:01:09 |
Message-ID: | 45D2C1C5.1050101@cox.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On 02/14/07 01:36, A. Kretschmer wrote:
> am Tue, dem 13.02.2007, um 13:56:15 -0800 mailte vanessa folgendes:
>> 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
>
> You can extract the week from a given date with this:
>
> SELECT EXTRACT(WEEK FROM '2006-01-01'::date);
>
> Be careful, the 1.1. can be in the 52. week in the last year. If you
> know the first day in the year in week 1, then you can add 7* the given
> week-1 days to this date.
I think she wants to do the opposite: cast 2004w1 to YYYY-MM-DD format.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
iD8DBQFF0sHFS9HxQb37XmcRAqClAJ4zkTJU7hT4vSbNM/8HyRqJwbSc1wCfeGJk
Tqr6q1YDe+TajGEY50Bl26Y=
=8i3I
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Sujay Bhattacharya | 2007-02-14 08:01:39 | Thank you for your email |
Previous Message | Peter Eisentraut | 2007-02-14 07:45:35 | [ANNOUNCE] Advisory on possibly insecure security definer functions |