Postgres Pro
Downloads
Home   >   mailing lists

Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions - Mailing list pgsql-general

From Vinayak
Subject Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions
Date
Msg-id 1409545329555-5817107.post@n5.nabble.com
Whole thread Raw
In response to Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions  (Steve Crawford <scrawford@pinpointresearch.com>)
Responses Re: Re: Timezone difference between Oracle SYSDATE and PostgreSQL timestamp functions
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Small fix in PG 9.4b2 - pg_env.sh
Next
From: Guillaume Lelarge
Date:
Subject: Re: Performance issue with postgres_fdw