convert timezone to string ...

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: convert timezone to string ...
Date: 2005-10-25 05:42:11
Message-ID: 20051025023901.Y56706@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


I know that the server knows that ADT == -0400, and AST == -0300 ... is
there any way of reversing that? Basically, I want to say:

SELECT timezone_str(-0400, 'not dst');

and have it return ADT ... I've got a method of doing it right now, using
a function, but just find it looks so messy, just wondering if there is a
clean way of doing it ...

Thanks ...

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message PFC 2005-10-25 08:07:39 Re: automatic update or insert
Previous Message elein 2005-10-25 03:08:37 Re: how to create rule as on delete