Home > mailing lists

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

From	Om Prakash Jaiswal
Subject	Getting wrong time using now()
Date	February 12, 2019 23:36:06
Msg-id	747290055.2254380.1550014566188@mail.yahoo.com Whole thread Raw
Responses	Re: Getting wrong time using now() Re: Getting wrong time using now() Re: Getting wrong time using now() Re: Getting wrong time using now()
List	pgsql-general

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

Bangalore, India

From: Rich Shepard
Date: 12 February 2019, 23:20:29
Subject: Re: Subquery to select max(date) value

From: Ken Tanzer
Date: 12 February 2019, 23:38:26
Subject: Re: Subquery to select max(date) value