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) ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
