Re: Odd timezone backend output - Mailing list pgsql-hackers

Tom Lane wrote:
> Andrew Chernow <ac@esilo.com> writes:
>> I am confused about the below results.  The backend is in EDT but it is 
>> converting timestamps into EST ... excluding NOW().  Regardless of the 
>> timezone provided, the backend is dishing out EST.
> 
> Try a date that's actually during the EDT part of the year.
> 
>             regards, tom lane
> 

Different systems do different things with Daylight time.  For instance: 
NTFS adjusts winter file times while in daylight savings (A file time of 
Jan 20 6PM reads Jan 20 7PM while in Daylight Time).  Whether that is 
good or bad is a different story.  I don't really have a problem with 
either, just needed a little clarity.

Thanks,
-- 
Andrew Chernow
eSilo, LLC
every bit counts
http://www.esilo.com/