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'),'-mm-dd hh12:MI:SS') AS winter,
>to_char(CONVERT_TO_UTC( '2011-04-22 14:17:00+02'::timestamptz
,'CET'),'-mm-dd hh24:MI:SS') AS summer;
T
On 04/16/2011 05:02 AM, Jasen Betts wrote:
On 2011-04-15, LaraK wrote:
Hello,
I want write a function that converts a timestamp with time zone to the UTC
zone. But it should all be stored in the winter time.
Done! All timestamp with time zone information is stored internally in UTC.
But you
