Getting wrong time using now()

From: Om Prakash Jaiswal <op12om(at)yahoo(dot)co(dot)in>
To: Postgres General <pgsql-general(at)postgresql(dot)org>, Postgres List <pgsql-sql(at)postgresql(dot)org>
Subject: Getting wrong time using now()
Date: 2019-02-12 23:36:06
Message-ID: 747290055.2254380.1550014566188@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql

Create table service_record(Id into, time timestamp without time zone default now()).Postgresql version 9.6.6, RHEL7.6 , when I am executing the query. I am getting time 5:30hours behind current time. Please solve it

RegardsOm PrakashBangalore, India

Sent from Yahoo Mail on Android

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ken Tanzer 2019-02-12 23:38:26 Re: Subquery to select max(date) value
Previous Message Rich Shepard 2019-02-12 23:20:29 Re: Subquery to select max(date) value

Browse pgsql-sql by date

  From Date Subject
Next Message Adrian Klaver 2019-02-12 23:40:50 Re: Getting wrong time using now()
Previous Message github kran 2019-02-12 18:55:46 Re: Postgresql RDS DB Latency Chossing Hash join Plan