[SQLite] Web SQL search on dates

select * from dates
where dte = date('now');

select dtm from datetimes
where dtm >= datetime(date('now'))
and dtm < datetime(date('now', '+1 day'));

select datetime(dtm, 'unixepoch', 'localtime') from unix
where dtm >= strftime('%s', date('now'))
and dtm < strftime('%s', date('now', '+1 day'));

http://hangaebal.blogspot.kr/2014/06/web-sql-search-on-dates.html
https://gist.github.com/dwurf/8929425