i have a table with a 'timstamp with time zone' column.
when i insert into it:
'18 Nov 2004 00:00:00 PST'
...it looks like:
2004-11-18 03:00:00-05
...once stored in the database.
0 o'clock vs. 3 o'clock.
is it storing in the time zone of the actual server or something? not
sure where my db server
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
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
