TS value in variable tables off by 5 hours

Posted on
Fri Feb 22, 2019 6:42 pm
towsled offline
Posts: 32
Joined: Jul 19, 2014

TS value in variable tables off by 5 hours

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?

Posted on
Fri Feb 22, 2019 8:09 pm
matt (support) offline
Site Admin
User avatar
Posts: 21411
Joined: Jan 27, 2003
Location: Texas

Re: TS value in variable tables off by 5 hours

Indigo always stores the timestamps in GMT, so you'll need to convert/adjust them when reading from the database.

Image

Posted on
Fri Feb 22, 2019 10:12 pm
kw123 offline
User avatar
Posts: 8333
Joined: May 12, 2013
Location: Dallas, TX

Re: TS value in variable tables off by 5 hours

Matt,

is there not a difference between using sqlite and postgres for TS?

Karl

Posted on
Sat Feb 23, 2019 1:44 pm
matt (support) offline
Site Admin
User avatar
Posts: 21411
Joined: Jan 27, 2003
Location: Texas

Re: TS value in variable tables off by 5 hours

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.

Image

Page 1 of 1

Who is online

Users browsing this forum: No registered users and 2 guests

cron