Because you're converting your UTC time to UTC. On Fri, Apr 21, 2017 at 4:03 PM, Rob Richardson <rdrichard...@rad-con.com> wrote:
> Hello! > > I'm in the Eastern US time zone, in daylight savings time. I am four > hours earlier than UTC time. I have a column that stores UTC times as > Julian times (floating-point numbers). The latest data point in the table > was stored at about 8:41 this morning (4/21). > > I am getting strange results from this query: > select max(value_timestamp), > datetime(max(julianday(value_timestamp)), 'localtime'), > datetime(max(julianday(value_timestamp)), 'utc') from trend_data > > The results are: > 2457864.86179398 > 2017-04-21 04:40:59 > 2017-04-21 12:40:59 > > How is it that switching from local time to UTC gives an eight-hour > difference? > > Thank you very much. > > RobR > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
