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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
