Re: Getting wrong time using now()

Om Prakash Jaiswal 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 LOCALTIM

Re: 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:).

Getting wrong time using now()

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 RegardsOm PrakashBangalore, India Sent from Yahoo Mail on Android