Finding ports by install date?

[Harald Hanche-Olsen]

> 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