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)