2014년 6월 16일 월요일

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'))
;



https://gist.github.com/dwurf/8929425

댓글 없음:

댓글 쓰기