Finding ports by install date?

Harald Hanche-Olsen hanche at
Mon May 30 13:21:14 PDT 2016

> Is there a way to search for ports installed on a given date? I want to find ports I installed 
> on a specific date and uninstall them. 

Absent a built-in method, the following seems to work correctly: 

sqlite3 /opt/local/var/macports/registry/registry.db "select name from ports where date(date,'unixepoch')=='2016-05-27’" 

It’s a bit jarring that “date” names both a function and a database field, but sqlite is not confused by this, thank goodness. 

– Harald 

More information about the macports-users mailing list