Postgres Pro
Downloads
Home   >   mailing lists

Getting wrong time using now() - Mailing list pgsql-general

From Om Prakash Jaiswal
Subject Getting wrong time using now()
Date
Msg-id 747290055.2254380.1550014566188@mail.yahoo.com
Whole thread Raw
Responses Re: Getting wrong time using now()  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Getting wrong time using now()  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Getting wrong time using now()  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Getting wrong time using now()  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
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


Regards
Om Prakash

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Subquery to select max(date) value
Next
From: Ken Tanzer
Date:
Subject: Re: Subquery to select max(date) value