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
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
