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 actually, physically is.
if so, does that imply that i can translate these stored dates to any
target time zone of my choosing when selecting the date from the db?
- philip