Page 1 of 1

SQL login time different

PostPosted: Wed Dec 13, 2017 5:36 pm
by jblackburn
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

Re: SQL login time different

PostPosted: Wed Dec 13, 2017 5:58 pm
by kw123
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