Re: Date Timezone

Thankyou very much.

You have fixed my synax issues!

It is much appreciated.

Andrew

On Nov 23, 2007 8:51 AM, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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/
___________________________________________