SQL login time different

Posted on
Wed Dec 13, 2017 5:36 pm
jblackburn offline
Posts: 77
Joined: Dec 11, 2013
Location: Quebec, Canada

SQL login time different

Hi,

Since few weeks, the database date/time (ts) column is offset from the computer (+5hrs)... It looks like the SQL engine used a different time zone. Is it possible? If yes, how can I change this to match my server time setup?

Thanks!

Joël

Posted on
Wed Dec 13, 2017 5:58 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: SQL login time different

One is utc the other is local time. SQLite and Postgres store the time differently in indigo.
Could it be that you changed time Zone somewhere ?
In Postgres I believe the time column is local time in SQLite it is utc.



Sent from my iPhone using Tapatalk

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 3 guests