Re: Best practices: Handling Daylight-saving time

>> 3) If I retrieve them without "at time zone" I will get them with
>> the time zone that was stored in the first place, right ?
> [...]
>
> This would be news to me. I don't think it's possible to *not* have a
> timezone set on a session. The server will have a default timezone
> based either on the local (server) system time or the setting of the
> timezone variable in postgresql.conf. Additionally, libpq
> applications will, I believe, issue a "set timezone" during initial
> connection setup.

This is certainly the default behavior--I don't know whether there are
settings to change it. All I know is that I regularly work with a database
located in a different time zone, and displayed times are adjusted to my
local time.

--
Scott Ribe
scott_ribe(at)killerbytes(dot)com
http://www.killerbytes.com/
(303) 665-7007 voice