I find it difficult to understand you. But the input I can not change: >SELECT >to_char(CONVERT_TO_UTC( '2011-03-22 14:17:00+01'::timestamptz ,'CET'),'yyyy-mm-dd hh12:MI:SS') AS winter, >to_char(CONVERT_TO_UTC( '2011-04-22 14:17:00+02'::timestamptz ,'CET'),'yyyy-mm-dd hh24:MI:SS') AS summer;
The system must know alone when is summertime and when is wintertime. Can it this? -- View this message in context: http://postgresql.1045698.n5.nabble.com/convert-in-GMT-time-zone-without-summer-time-tp4304830p4310095.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
