Re: timestamp with time zone question...

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
>