Andrew Chernow wrote:
Tom Lane wrote:
Andrew Chernow <[EMAIL PROTECTED]> 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
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers