Skip to content

Instantly share code, notes, and snippets.

@doyle

doyle/things.sql

Created February 17, 2014 23:11
Show Gist options
  • Save doyle/9061166 to your computer and use it in GitHub Desktop.
Save doyle/9061166 to your computer and use it in GitHub Desktop.
Download ZIP
How to query record's from Cultured Code's Thing's sqlite database
Raw
things.sql
select ZTITLE, date(ZSTOPPEDDATE, 'unixepoch', '+31 years') as completed from zthing where completed is not null group by completed;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment