At 12:09 PM 4/01/2001 -0500, you wrote: >No, the times in the database are all GMT. They will get *displayed* >with some particular timezone offset, as determined by the TIMEZONE >SET variable. > >You have to set TIMEZONE to your local timezone if you want dates >displayed in something other than the server's default timezone. >Perhaps what you are really looking for is the PGTZ environment >variable. If you keep PGTZ set in your environment, libpq will issue >the SET TIMEZONE command for you during connection startup. > > regards, tom lane After further investigation it turns out I am looking for a timestamp and timetz hybrid. Possibly timestamptz ? :) My solution has been to store the timezone offset in a int4 field, then apply that offset when selecting data from my timestamp type fields. Regards, Blake Crosby
