Date: Wed, 9 Sep 2015 11:05:09 -0700 From: jungle Boogie <jungleboogie0@gmail.com> To: freebsd-pkg@freebsd.org Cc: jungle Boogie <jungleboogie0@gmail.com> Subject: Re: pkg list installed by date Message-ID: <CAKE2PDt=WxeL7OG603OjmCsp3t9%2BNQhOzsVznNNE3maaFAQxvA@mail.gmail.com>
next in thread | raw e-mail | index | archive | help
Hi Matthew, >> I want to list installed packages by their install/update timestamp. > >> % pkg query %n-%t >> and >> % pkg query %t-%n >> >> List packages installed alphabetically. > pkg-query(8) doesn't provide any sorting capabilities. However, it is > fairly trivial to pipe the output into sort(1) But pkg uses a sqlite3 database. Can't I alter the query? It somehow has a query to sort alphabetically. >> Also is the %t UTC or local time? > Neither. It's the unix time -- seconds since the epoch, where the epoch > date is: > % env TZ=UTC date -j -f %s 0 > Thu Jan 1 00:00:00 UTC 1970 > or the same time in whatever timezone you inhabit. Yes, I should have more clear but that helps. -- ------- inum: 883510009027723 sip: jungleboogie@sip2sip.info xmpp: jungle-boogie@jit.si
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAKE2PDt=WxeL7OG603OjmCsp3t9%2BNQhOzsVznNNE3maaFAQxvA>