Am Mittwoch, 14. Februar 2007 11:53 schrieb Alban Hertroys:
> I think you're looking for this:
>
> select to_date('01 2004', 'WW ');
> to_date
>
> 2004-01-01
> (1 row)
Or possibly to_date('01 2004', 'IW IYYY'), depending on taste.
--
Peter Eisentraut
http://developer.postgres
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
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 on
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 03:33, A. Kretschmer wrote:
> am Wed, dem 14.02.2007, um 3:10:17 -0600 mailte Ron Johnson folgendes:
>> -BEGIN PGP SIGNED MESSAGE-
>> Hash: SHA1
>>
>> On 02/14/07 02:52, A. Kretschmer wrote:
>>> am Tue, dem 13.02.2007, um 13:56:1
am Wed, dem 14.02.2007, um 3:10:17 -0600 mailte Ron Johnson folgendes:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 02/14/07 02:52, A. Kretschmer wrote:
> > am Tue, dem 13.02.2007, um 13:56:15 -0800 mailte vanessa folgendes:
> [snip]
> >
> > test=*# select get_week(2007,2);
> >
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 02:52, A. Kretschmer wrote:
> am Tue, dem 13.02.2007, um 13:56:15 -0800 mailte vanessa folgendes:
[snip]
>
> test=*# select get_week(2007,2);
> get_week
> -
> 08-01-2007 - 14-01-2007
> (1 row)
Is that wee
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 s
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/14/07 02:13, A. Kretschmer wrote:
> am Wed, dem 14.02.2007, um 2:01:09 -0600 mailte Ron Johnson folgendes:
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 co
am Wed, dem 14.02.2007, um 2:01:09 -0600 mailte Ron Johnson folgendes:
> >> 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
-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 postgresq
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 s
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
12 matches
Mail list logo