On 6/28/2016 3:05 PM, Simon Slavin wrote:
SELECT device,HEX(device) FROM myTable WHERE
Thanks, Simon. Now it's getting really strange. Two queries and their results are shown below. The value of "device" seems to be the same in both rows. One query includes the field "localtime" and the other doesn't. Perhaps I should not be using "localtime" as a field name. I know it's a modifier to strftime().
(1) select rowid, device, hex(device), localtime, udatetime from eventlog where device like '%M14' and udatetime=1415000934 rowid device hex(device) localtime udatetime 18031 M14 4D3134 2014-11-03 01:48:54 1415000934 18062 M14 4D3134 2014-11-03 01:48:54 1415000934 (2) select rowid, device, hex(device), udatetime from eventlog where device like '%M14' and udatetime=1415000934 rowid device hex(device) udatetime 18062 M14 4D3134 1415000934 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users