Jaromír Talíř <jaromir.talir@xxxxxx> writes: > postgres# select '2008-06-01 10:10:10 UTC' AT TIME ZONE 'CET'; > timezone > --------------------- > 2008-06-01 12:10:10 ISTM this is the one that's wrong. "CET" is standard time, it, GMT+1. If you want a timezone which switches between CET and CST automatically you should use something like Europe/Paris. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!