On 08/31/2014 09:22 PM, Vinayak wrote:
Thank you for reply.
The time return by SYSDATE depends on the OS timezone setting while in
PostgreSQL we can set the timezone using 'set time zone..' statement so here
timezone setting depends on DBMS but I think there are not so many systems
that use different timezone settings between DBMS and OS.
I would say that needs clarification. If you have a database running on
a server and getting its timezone from the server OS and multiple
clients running across many timezones each with a different OS timezone,
then the above is not strictly true. So, exactly which machine OS are
you talking about?
-----
Regards,
Vinayak,
--
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
