Date: Tue, 12 Feb 2019 23:36:06 +0000 (UTC)
From: Om Prakash Jaiswal <op12om@yahoo.co.in>
Reply-To: "op12om@yahoo.co.in" <op12om@yahoo.co.in>
To: Postgres General <pgsql-general@postgresql.org>,
	Postgres List <pgsql-sql@postgresql.org>
Message-ID: <747290055.2254380.1550014566188@mail.yahoo.com>
Subject: Getting wrong time using now()
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_2254379_1734309291.1550014566187"
References: <747290055.2254380.1550014566188.ref@mail.yahoo.com>
Content-Length: 1491
Precedence: bulk

------=_Part_2254379_1734309291.1550014566187
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

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
------=_Part_2254379_1734309291.1550014566187
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 7bit

Create table service_record(Id into, time timestamp without time zone default now()).<div id="yMail_cursorElementTracker_1550014414767">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</div><div id="yMail_cursorElementTracker_1550014537652"><br></div><div id="yMail_cursorElementTracker_1550014538058"><br></div><div id="yMail_cursorElementTracker_1550014538302">Regards</div><div id="yMail_cursorElementTracker_1550014543628">Om Prakash</div><div id="yMail_cursorElementTracker_1550014548009">Bangalore, India<br><br><div id="ymail_android_signature"><a id="ymail_android_signature_link" href="https://go.onelink.me/107872968?pid=InProduct&amp;c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&amp;af_wl=ym&amp;af_sub1=Internal&amp;af_sub2=Global_YGrowth&amp;af_sub3=EmailSignature">Sent from Yahoo Mail on Android</a></div></div>
------=_Part_2254379_1734309291.1550014566187--