new file: podcasts/podcatchers.mdwn
authorPhilip Durbin <philipdurbin@gmail.com>
Thu, 22 Mar 2018 00:34:06 +0000 (20:34 -0400)
committerPhilip Durbin <philipdurbin@gmail.com>
Thu, 22 Mar 2018 00:34:06 +0000 (20:34 -0400)
podcasts/podcatchers.mdwn [new file with mode: 0644]

diff --git a/podcasts/podcatchers.mdwn b/podcasts/podcatchers.mdwn
new file mode 100644 (file)
index 0000000..c716c4c
--- /dev/null
@@ -0,0 +1,3 @@
+AntennaPod: https://github.com/AntennaPod/AntennaPod
+
+    select datetime(SUBSTR(pubdate, 1,LENGTH(pubdate)-3),'unixepoch','localtime') as pubdate,title from FeedItems where read=1 order by pubdate;