Page 1 of 1
TS value in variable tables off by 5 hours
Posted:
Fri Feb 22, 2019 6:42 pmby towsled
I have been logging some variables for some time now and love SQL Logger; but during a recent analysis I was performing I discovered that the 'TS' timestamp is exactly 5 hours off the actual time. Where does the TS value come from and is there a way to adjust it against the actual system time?
Re: TS value in variable tables off by 5 hours
Posted:
Fri Feb 22, 2019 8:09 pmby matt (support)
Indigo always stores the timestamps in GMT, so you'll need to convert/adjust them when reading from the database.
Re: TS value in variable tables off by 5 hours
Posted:
Fri Feb 22, 2019 10:12 pmby kw123
Matt,
is there not a difference between using sqlite and postgres for TS?
Karl
Re: TS value in variable tables off by 5 hours
Posted:
Sat Feb 23, 2019 1:44 pmby matt (support)
If I remember correctly the timestamps are stored as GMT in both, but PostgreSQL is better about auto-converting to local times when selecting the data out.