Here's the command line:
Code: Select all
sqlite3 ~/mylar/mylar.db "select * from issues where ReleaseDate is '0000-00-00' ;" | sed -e s/\|/\,/g > missing.csv
Code: Select all
sqlite3 ~/mylar/mylar.db "select * from issues where ReleaseDate is '0000-00-00' ;" | sed -e s/\|/\,/g > missing.csv