Re: timestamp with time zone tutorial

Hey Tom,
I was trying to use 'US/Pacific-New' as my long, unabbreviated timezone and it wasn't working. I thought postgres wasn't accepting the unabbreviated, geopolitical, daylight savings time, time zones. Turns out, the server that I was on, (not my own box), didn't have that in the '/usr/share/zoneinfo/US' directory. My bad.

I just have to read more on how to get it out relative to a different time zone than it went in. I'll find it.

Dennis Gearon

Signature Warning
----------------
EARTH has a Right To Life

I agree with Bolivian President Evo Morales

# The right to life: "The right for no ecosystem to be eliminated by the irresponsible acts of human beings."

# The right of biosystems to regenerate themselves: "Development cannot be infinite. There's a limit on everything."

# The right to a clean life: "The right for Mother Earth to live without contamination, pollution. Fish and animals and trees have rights."

# The right to harmony and balance between everyone and everything: "We are all interdependent."

See the movie - 'Inconvenient Truth'
See the movie - 'Syriana'

--- On Sun, 7/19/09, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> Subject: Re: [GENERAL] timestamp with time zone tutorial
> To: "Dennis Gearon" <gearond(at)sbcglobal(dot)net>
> Cc: pgsql-general(at)postgresql(dot)org
> Date: Sunday, July 19, 2009, 8:00 PM
> Dennis Gearon <gearond(at)sbcglobal(dot)net>
> writes:
> >      What I want is to be able to
> insert into my project's database, times given by anybody
> anywhere on the planet (the SUBMITTER), add the appropriate
> timezone in the insert statement so that it in 'GMT/UMT'
> neutral'. I believe this is the way Postgres does it,
> storing times in GMT time.
>
> So just do it.  What do you need to_timestamp
> for?  The basic
> timestamptz input function is far more likely to get it
> right
> for input that's not in a precise predetermined format.
>
>            
> regards, tom lane
>