On 2/12/19 3:36 PM, Om Prakash Jaiswal wrote:
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
Move clock back 5:30 hours:).
On serious note:
1) I would change the time field to timestamp with timezone.
2) Verify what timezone the server is running on:
show timezone;
TimeZone
------------
US/Pacific
Regards
Om Prakash
Bangalore, India
Sent from Yahoo Mail on Android
<https://go.onelink.me/107872968?pid=InProduct&c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&af_wl=ym&af_sub1=Internal&af_sub2=Global_YGrowth&af_sub3=EmailSignature>
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
