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.
Best regards,
A
--
Andrew Sullivan
ajs@crankycanuck.ca