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 <[email protected]> wrote:
> From: Tom Lane <[email protected]>
> Subject: Re: [GENERAL] timestamp with time zone tutorial
> To: "Dennis Gearon" <[email protected]>
> Cc: [email protected]
> Date: Sunday, July 19, 2009, 8:00 PM
> Dennis Gearon <[email protected]>
> 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 ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
