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 <t...@sss.pgh.pa.us> wrote:

> From: Tom Lane <t...@sss.pgh.pa.us>
> Subject: Re: [GENERAL] timestamp with time zone tutorial
> To: "Dennis Gearon" <gear...@sbcglobal.net>
> Cc: pgsql-general@postgresql.org
> Date: Sunday, July 19, 2009, 8:00 PM
> Dennis Gearon <gear...@sbcglobal.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
>

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to