Getting wrong time using now()

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&amp;c=Global_Internal_YGrowth_AndroidEmailSig__AndroidUsers&amp;af_wl=ym&amp;af_sub1=Internal&amp;af_sub2=Global_YGrowth&amp;af_sub3=EmailSignature&gt;

--
Adrian Klaver
adrian.klaver@aklaver.com

Om Prakash Jaiswal <op12om@yahoo.co.in> writes:

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

Well, you probably ought to be using LOCALTIMESTAMP, not now(),
as the initializer for a "timestamp without time zone" value,
if only to save a useless runtime datatype conversion. See

https://www.postgresql.org/docs/current/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

However, if the results don't look right to you, it probably
means that you don't have the timezone parameter set correctly.

regards, tom lane