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:
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';
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
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/