On Fri, Dec 16, 2011 at 3:43 AM, Hans-Henrik Fuxelius <hfuxel...@gmail.com> wrote: > It seems not possible to suppress to_timestamp from doing daylight > saving conversion, I have GPS timeseries that looks perfect in the > 'timestamp without time zone' save one value that wreck the whole time > serie, does that mean that time series cant be stored in time stamps?
I think it mostly means that you shouldn't use timestamp without time zone. Or else you should use a time zone setting that doesn't involve DST. Throwing away the time zone information is bad, because YYYY-MM-DD HH:MM:SS doesn't uniquely identify a point in time, even if you know what time zone it's relative to. That combination of years, minutes, days, hours, minutes, and seconds can occur twice, if it's near a DST boundary. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
