On 08/28/2014 10:06 PM, Vinayak wrote:
Hello,
We have converted Oracle SYSDATE to PostgreSQL statement_timestamp() but
there is a difference in timezone.
SYSDATE returns the time on the server where the database instance is
running(returns operating system time) so the time depends on the OS
time
Vinayak wrote:
> We have converted Oracle SYSDATE to PostgreSQL statement_timestamp() but
> there is a difference in timezone.
> SYSDATE returns the time on the server where the database instance is
> running(returns operating system time) so the time depends on the OS
> timezone setting.
> while t
On 8/28/2014 10:06 PM, Vinayak wrote:
Any idea how can we set OS timezone on PostgreSQL?
timestamp with time zone values are stored as the equivalent of UTC and
converted to the client TIME_ZONE setting for display, unless you
specify some other timezone via AT TIME ZONE
I'm not sure why an
Hello,
We have converted Oracle SYSDATE to PostgreSQL statement_timestamp() but
there is a difference in timezone.
SYSDATE returns the time on the server where the database instance is
running(returns operating system time) so the time depends on the OS
timezone setting.
while the timezone of postg
