Re: timestamp with time zone question... - Mailing list pgsql-general

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