Barton Torbert wrote:
> Even though this is a bit more complicated, it does seem to work
> correctly.
>
> SELECT t1.realdate1,
> t2.realdate2
> from test_table_1 t1 left outer join test_table_2 t2 where
> strftime ('%s', t2.realdate2) between strftime ('%s',
> datetime(t1.realdate1, '-1 minutes') ) and strftime ('%s',
> datetime(t1.realdate1, '+1 minutes') )
This would lose any benefit of the index on realdate2, in case you have
one.
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
