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
