Thankyou very much.
You have fixed my synax issues!
It is much appreciated.
Andrew
On Nov 23, 2007 8:51 AM, Alvaro Herrera <
alvherre@alvh.no-ip.org> 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/___________________________________________