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-05-03 07:15:21
Message-ID: 1304406921088-4366565.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Very good!

Another question:
I want to convert the string to the type TIMESTAMP WITH TIME ZONE. What do I
have to format? 'TZ' does not.

select to_timestamp('2011-03-22 14:17:00 Europe/Berlin', 'YYYY-MM-DD
HH:MI:SS TZ')
---
FEHLER: Formatmuster »TZ«/»tz« werden in to_date nicht unterstützt

--
View this message in context: http://postgresql.1045698.n5.nabble.com/convert-in-GMT-time-zone-without-summer-time-tp4304830p4366565.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Marc Mamin 2011-05-03 08:07:58 checking for the existence of a current_setting ?
Previous Message Pavel Stehule 2011-05-03 02:10:10 Re: [SQL] PLpgSQL variables persistance between several functions calls