Skip to content

Latest commit

 

History

History
8 lines (6 loc) · 254 Bytes

SQLITE.md

File metadata and controls

8 lines (6 loc) · 254 Bytes

try SQLite online https://sqliteonline.com/.

use SQLite query and todo as tasks,

  1. this snippets query todo more than 1 day.
SELECT * FROM blocks WHERE strftime('%Y%m%d%H%M%S','now') - updated < 1000000 AND subtype = 't' AND type = 'i'