Andrew Chernow wrote:
> 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.
>
>
The only file times we should ever be interested in are surely epoch
times, which should be unaffected by time zones.
cheers
andrew