Re: [GENERAL] timestamp with time zone question...

2004-11-21 Thread P. George
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:

Re: [GENERAL] timestamp with time zone question...

2004-11-21 Thread Michael Glaesemann
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';

Re: [GENERAL] timestamp with time zone question...

2004-11-21 Thread P. George
See the documentation for Date/Time Types and Date/Time Functions and Operators: http://www.postgresql.org/docs/7.4/static/datatype-datetime.html http://www.postgresql.org/docs/7.4/static/functions-datetime.html if so, does that imply that i can translate these stored dates to any target time zone

Re: [GENERAL] timestamp with time zone question...

2004-11-21 Thread Michael Fuhr
On Sun, Nov 21, 2004 at 07:58:37PM -0600, P. George wrote: > is it storing in the time zone of the actual server or something? not > sure where my db server actually, physically is. See the documentation for Date/Time Types and Date/Time Functions and Operators: http://www.postgresql.org/docs/