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

Reply via email to