On 02/19/2014 01:02 PM, Andrew Sullivan wrote:
On Thu, Feb 20, 2014 at 02:24:53AM +0530, Dev Kumkar wrote:
Ok but am confused then, as if no timezone parameter is defined in
postgreSQL.conf file then yes UTC time is returned. "Select now()"
but if timezone parameter is set then "Select now()" returns date time as
per timezone.
Try issuing SET TimeZone commands. I think you'll find that the
client can set whatever time zone it wants.
I think what the OP wants is to know how Postgres sets TimeZone in
postgresql.conf when a cluster is created via initdb on Windows?
Best regards,
A
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
