From owner-freebsd-pkg@freebsd.org Wed Sep 9 07:05:12 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 13511A00404 for ; Wed, 9 Sep 2015 07:05:12 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from smtp.infracaninophile.co.uk (smtp.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 93C9A1171 for ; Wed, 9 Sep 2015 07:05:11 +0000 (UTC) (envelope-from matthew@FreeBSD.org) Received: from liminal.local (liminal.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3636:3bff:fed4:b0d6]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.15.2/8.15.2) with ESMTPSA id t89752XO082855 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NO) for ; Wed, 9 Sep 2015 08:05:02 +0100 (BST) (envelope-from matthew@FreeBSD.org) Authentication-Results: smtp.infracaninophile.co.uk; dmarc=none header.from=FreeBSD.org DKIM-Filter: OpenDKIM Filter v2.10.3 smtp.infracaninophile.co.uk t89752XO082855 Authentication-Results: smtp.infracaninophile.co.uk/t89752XO082855; dkim=none; dkim-atps=neutral X-Authentication-Warning: lucid-nonsense.infracaninophile.co.uk: Host liminal.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3636:3bff:fed4:b0d6] claimed to be liminal.local Subject: Re: pkg list installed by date To: freebsd-pkg@freebsd.org References: From: Matthew Seaman Message-ID: <55EFDA12.2060702@FreeBSD.org> Date: Wed, 9 Sep 2015 08:04:50 +0100 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:38.0) Gecko/20100101 Thunderbird/38.2.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="2g2dEKfs0NF0L0nVHGN63bDR5Dlo0m4kV" X-Virus-Scanned: clamav-milter 0.98.7 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.7 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham autolearn_force=no version=3.4.1 X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on lucid-nonsense.infracaninophile.co.uk 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 07:05:12 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --2g2dEKfs0NF0L0nVHGN63bDR5Dlo0m4kV Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On 08/09/2015 22:52, jungle Boogie wrote: > Hello, >=20 > Requesting help with simple query. >=20 > I want to list installed packages by their install/update timestamp. >=20 > % pkg query %n-%t > and > % pkg query %t-%n >=20 > 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) > 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=3DUTC date -j -f %s 0 Thu Jan 1 00:00:00 UTC 1970 or the same time in whatever timezone you inhabit. Cheers, Matthew --2g2dEKfs0NF0L0nVHGN63bDR5Dlo0m4kV Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2 iQJ8BAEBCgBmBQJV79oaXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ2NTNBNjhCOTEzQTRFNkNGM0UxRTEzMjZC QjIzQUY1MThFMUE0MDEzAAoJELsjr1GOGkAT/nIP/Aqxtl8mctqemYftp+7CtI7Q hetuO+7MRjyo/fYd8K2atm2OSNKd19dME+1b84256JFzRivVw4M8B6UfkB1zdvdU 4zqMOJuUZKC3Q5qQ7wIToeGLdg9U32LteByunOlDYtiOqd6qdsTPTadSwv+zkjx1 j+mDQIaW9F07kMXdFLwpeWphL3Tp6qtE+6n8PbC5DQETm3v24vgVlygg4rdXpvO6 dhhPNLH0gBGUnRdHL3AlSExu0cjbqeO5wCIF9wsJB+fK+lHbvvtYzy+kNVU2gqXZ B25WCPABYlU3Q+9p9T0E6xbBCllAouIICzKRpzVr35rwnR49HLDENXQqyKIlocMf ORIYI/CDFo8rGkxKtHW8CZ3E0ey9xSkt6Z80nmVAJV/TvZaRmLSOlBhGDwjQlMRm +8n3TksXFblABBmKVqqZbxkdTJakArawAA0opATjeYScIyGR+O3QMp5BuvPVmJqN WpfoXJJ9Z+NcEj0O/7XZN5G27uU21MJz1TnWA8mb8uqW9Oc9X+z9MjBD9Yc7+RCm cMJ5b4N/xnNqtBh2IXGzRGk8lw3aJLu2nOvLeQoMIfqLS7jn5je0amzdiob9Cv05 NnslgOR3TmP4lHclVdiTp93D8LEVV0TzGGW7EKMJbkrFR+Ykpa4kufnElVZE4+Aj bH8mPUbELizqBV+8xy2t =cbug -----END PGP SIGNATURE----- --2g2dEKfs0NF0L0nVHGN63bDR5Dlo0m4kV--