| From: | "Magnus Hagander" <mha(at)sollentuna(dot)net> |
|---|---|
| To: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: convert timezone to string ... |
| Date: | 2005-10-25 11:03:19 |
| Message-ID: | 6BCB9D8A16AC4241919521715F4D8BCE92E79F@algol.sollentuna.se |
| Views: | Whole Thread | Raw Message | 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 ...
How would you know *which* timezone to go back to? For every hourly
offset there is a whole set of timezones that would result in it...
//Magnus
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Wiebe Cazemier | 2005-10-25 12:07:40 | Re: writable joined view |
| Previous Message | PFC | 2005-10-25 08:07:39 | Re: automatic update or insert |