Re: convert in GMT time zone without summer time

From: LaraK <indarija(at)gmx(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: convert in GMT time zone without summer time
Date: 2011-04-18 07:10:31
Message-ID: 1303110631714-4310095.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Steve Crawford 2011-04-18 16:56:45 Re: convert in GMT time zone without summer time
Previous Message Jasen Betts 2011-04-16 12:13:01 Re: Get id of a tuple using exception