Thankyou very much. You have fixed my synax issues!
It is much appreciated. Andrew On Nov 23, 2007 8:51 AM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > 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 > -- ___________________________________________ Andrew J. P. Maclean Centre for Autonomous Systems The Rose Street Building J04 The University of Sydney 2006 NSW AUSTRALIA Ph: +61 2 9351 3283 Fax: +61 2 9351 7474 URL: http://www.acfr.usyd.edu.au/ ___________________________________________
