Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions

From: Vinayak <vinpokale(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions
Date: 2014-09-01 04:22:09
Message-ID: 1409545329555-5817107.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

-----
Regards,
Vinayak,

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Timezone-difference-between-Oracle-SYSDATE-and-PostgreSQL-timestamp-functions-tp5816851p5817107.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2014-09-01 05:48:49 Re: Performance issue with postgres_fdw
Previous Message Michael Paquier 2014-08-31 23:27:08 Re: Small fix in PG 9.4b2 - pg_env.sh