On 28 Jun 2016, at 11:22pm, Joe Pasquariello <j...@fenway.com> wrote:
> 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 SELECT udatetime,typeof(udatetime),udatetime-1415000934 FROM eventlog where device like '%M14' and udatetime=1415000934 PRAGMA integrity_check Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
