Subject: Re: Getting wrong time using now()
To: "op12om@yahoo.co.in" <op12om@yahoo.co.in>,
 Postgres General <pgsql-general@postgresql.org>,
 Postgres List <pgsql-sql@postgresql.org>
References: <747290055.2254380.1550014566188.ref@mail.yahoo.com>
 <747290055.2254380.1550014566188@mail.yahoo.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <187833af-6e2d-e84a-da49-62d6da8b2ccc@aklaver.com>
Date: Tue, 12 Feb 2019 15:40:50 -0800
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.3.0
MIME-Version: 1.0
In-Reply-To: <747290055.2254380.1550014566188@mail.yahoo.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk

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@aklaver.com