Finding ports by install date?

[Carlo Tambuatco]

Dude, thanks! 

Yeah the port -v installed does not list the dates for 2.3.4…wonder if previous versions ever did...


> On May 30, 2016, at 4:21 PM, Harald Hanche-Olsen <hanche at math.ntnu.no> wrote:
> 
>> 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 
>