SHOW ALL shows TimeZone is 'unknown'. postgres.conf says 'TZ' is used for default. Where should TZ be set (it doesn't appear to be set on my RH9 system)?
Thanks, CSN --- CSN <[EMAIL PROTECTED]> wrote: > > Does Postgres use the system's timezone > (/etc/localzone) at all? Or does "SET TIME ZONE > 'MST'" > need to be placed in postgres.conf to make it always > used (I set it via psql, but it appears to only be > set > for that connection)? > > Thanks, > CSN > > > --- Tom Lane <[EMAIL PROTECTED]> wrote: > > CSN <[EMAIL PROTECTED]> writes: > > > Is it possible to update the timezone part of > > > timestamp fields in a single query? I have a > bunch > > of > > > values that are -06 I need changed to -07. > > > > I suspect that you have a fundamental conceptual > > error. > > > > You cannot "update the timezone" because the > > timezone is not part of the > > stored value; it is part of the display operation. > > > Stored values for > > timestamptz columns are always effectively in UTC. > > > When the value is > > converted to a string for display, it is adjusted > to > > your current local > > timezone (per SET TIME ZONE) and that timezone is > > what's put on the > > output. > > > > So the basic answer is you don't change the data, > > you change your > > TIME ZONE setting from -6 to -7 if that's what you > > want to see. > > > > You might have an additional problem that the data > > was entered > > incorrectly, and is one hour off from reality > > because you were > > confused about time zones when you put it in. In > > that case you'd > > fix it with something like > > UPDATE tab SET col = col + '1 hour'::interval; > > > > regards, tom lane > > > __________________________________ > Do you Yahoo!? > Free Pop-Up Blocker - Get it now > http://companion.yahoo.com/ > __________________________________ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
