From: | "P(dot) George" <invest(at)juun(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: timestamp with time zone question... |
Date: | 2004-11-22 02:45:48 |
Message-ID: | 9D7045FC-3C30-11D9-AD7B-000D932AEE70@juun.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
oops. that did it. ;-)
thanks.
- philip
On Nov 21, 2004, at 8:42 PM, Michael Glaesemann wrote:
>
> On Nov 22, 2004, at 11:30 AM, P. George wrote:
>
>> well... the examples in the documentation work, but they only use
>> static dates (hard-coded, i mean):
>>
>> SELECT TIMESTAMP WITH TIME ZONE '2001-02-16 20:38:40-05' AT TIME ZONE
>> 'PST';
>>
>> but, when i try:
>>
>> SELECT mydatecolumn FROM mytable AT TIME ZONE 'PST';
>>
>> .... i get a parse error.
>>
>
> It would help if you included the exact error. However, one thing the
> examples in the docs show, is that the AT TIME ZONE follows the value,
> i.e.,
>
> SELECT mydatecolumn AT TIME ZONE 'PST' FROM mytable;
>
> hth
>
> Michael Glaesemann
> grzm myrealbox com
>
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2004-11-22 02:57:37 | Re: pgEdit public beta for Macintosh and Windows |
Previous Message | Michael Glaesemann | 2004-11-22 02:42:29 | Re: timestamp with time zone question... |