Re: Date Timezone

Andrew Maclean wrote:
> This extracts the time zone in seconds, but how do I add it to the datetime
> that I have?
>
> This is what I have been trying but it doesn't work:
> '2007-12-3'::timestamp + interval 'extract(timezone from now()) seconds'

'2007-12-3'::timestamp + extract(timezone from now()) * '1 second'::interval;

Please copy the list on replies.

--
Alvaro Herrera                        http://www.advogato.org/person/alvherre
"En el principio del tiempo era el desencanto.  Y era la desolación.  Y era
grande el escándalo, y el destello de monitores y el crujir de teclas."
                            ("Sean los Pájaros Pulentios", Daniel Correa)