Postgres Pro
Downloads
Home   >   mailing lists

Re: Does PG really lack a time zone for India? - Mailing list pgsql-general

From Tom Lane
Subject Re: Does PG really lack a time zone for India?
Date
Msg-id 20393.1140043134@sss.pgh.pa.us
Whole thread Raw
In response to Re: Does PG really lack a time zone for India?  ("Ken Winter" <ken@sunward.org>)
Responses Re: Does PG really lack a time zone for India?  ("Ken Winter" <ken@sunward.org>)
List pgsql-general
Tree view 
"Ken Winter" <ken@sunward.org> writes:
> Yes, that's what I'm trying to do.  My problem has been: how to enter the
> equivalent of '2006-02-15 10:22:46-05' when the time I want to enter and
> convert to EST is a variable value or now().

This still shows a problem in your grasp of what's going on.  now() is
absolute and should never need to be converted ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Ken Winter"
Date:
Subject: Re: Does PG really lack a time zone for India?
Next
From: Colin Shreffler
Date:
Subject: Pg_hba.conf issues