From owner-freebsd-pkg@freebsd.org Wed Sep 9 18:05:10 2015 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 8E4AFA0167D for ; Wed, 9 Sep 2015 18:05:10 +0000 (UTC) (envelope-from jungleboogie0@gmail.com) Received: from mail-io0-x22d.google.com (mail-io0-x22d.google.com [IPv6:2607:f8b0:4001:c06::22d]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 5EB391D88 for ; Wed, 9 Sep 2015 18:05:10 +0000 (UTC) (envelope-from jungleboogie0@gmail.com) Received: by iofb144 with SMTP id b144so32003504iof.1 for ; Wed, 09 Sep 2015 11:05:09 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:date:message-id:subject:from:to:cc:content-type; bh=obi36IMqTIR/CRzeXX2K0hgfrR1KZf+Ex/moL0oJ49I=; b=oh/u1Jw/a86r61IpkyJ2P5tubSGXUtwej7Blj7ESvO9EdAInU+XTdeKuchJ5/XUm1h lhMh+vNSSSbPyzKvpDFF3WsQ9qfK5Lx3C6oO6fozO/+kb3QtQmCLcLKp2El4mnewiGfO rMYYDYCY2VZhNyGbCIceY29z+feHtB+CP2PVueFHadouEhiZFABVzy+8zCttLTf3v+zV dgMIfGl/vd9F7qeKAJNnWsr5Wrp1QmaWoFkvrSFK7AkAwFSM1RPwd03MeAiOT5iSZziJ 8m+9Pcd6+uuJ1yYQWCuQNF4oSmm21RD3qc5o/blh46f+TfYoUz2JtNd6xVvvzyzgcZSF a35g== MIME-Version: 1.0 X-Received: by 10.107.131.16 with SMTP id f16mr52808383iod.100.1441821909626; Wed, 09 Sep 2015 11:05:09 -0700 (PDT) Received: by 10.79.14.10 with HTTP; Wed, 9 Sep 2015 11:05:09 -0700 (PDT) Date: Wed, 9 Sep 2015 11:05:09 -0700 Message-ID: Subject: Re: pkg list installed by date From: jungle Boogie To: freebsd-pkg@freebsd.org Cc: jungle Boogie Content-Type: text/plain; charset=UTF-8 X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 09 Sep 2015 18:05:10 -0000 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