From owner-freebsd-questions@freebsd.org Sat Jul 13 18:27:40 2019 Return-Path: Delivered-To: freebsd-questions@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id A5F5515EE132 for ; Sat, 13 Jul 2019 18:27:40 +0000 (UTC) (envelope-from freebsd@edvax.de) Received: from mout.kundenserver.de (mout.kundenserver.de [217.72.192.74]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client CN "mout.kundenserver.de", Issuer "TeleSec ServerPass Class 2 CA" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 67A418F9F9 for ; Sat, 13 Jul 2019 18:27:37 +0000 (UTC) (envelope-from freebsd@edvax.de) Received: from r56.edvax.de ([178.12.34.221]) by mrelayeu.kundenserver.de (mreue106 [212.227.15.183]) with ESMTPA (Nemesis) id 1MybbH-1igyHm0mbd-00yyu6; Sat, 13 Jul 2019 20:22:11 +0200 Date: Sat, 13 Jul 2019 20:22:07 +0200 From: Polytropon To: "@lbutlr" Cc: freebsd-questions@freebsd.org Subject: Re: pkg query timestamp format Message-Id: <20190713202207.4e7f827e.freebsd@edvax.de> In-Reply-To: <5343D197-AF3A-490E-AB75-F0624A77A3FE@kreme.com> References: <5D28CD7B.40102@webtent.org> <5343D197-AF3A-490E-AB75-F0624A77A3FE@kreme.com> Reply-To: Polytropon Organization: EDVAX X-Mailer: Sylpheed 3.1.1 (GTK+ 2.24.5; i386-portbld-freebsd8.2) Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Provags-ID: V03:K1:yu+R85xhHedJiOc3+ZWpJhM3jUENne2bmp0w1GueYhw7qebb5xS bFLqnAL8dutre/PoT2rEOJg96DmePFO9Oxqk24fyzED+Z6Ix21S/LDhmIzaJnrvG5PCAuut YSRQqoZkc//PokSBkaV9v3jDTYr6N+uvr7Dfk4W+nohx4brY3x/AeEnhzE2CDXN8kEGjAae Ec+2gwp01bp5/p6QlEiCg== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:e2RdMxHWY5w=:VTCF35nFUUZEMC2NUeBFxg IRbI1K6g7o3urPHCEzr3jtzqszL/yZo1IjpwEHOJrUr+Xq6e6R//eozJJcFbigTm1h2LhHAJc pWO8YQp5DIwp/oMSlP3LTCG4rRrY1AUz62QtCK7yWaU0w3m7001ZHqwEktzP/dpZR5SFvgDop drZQM1iniKc0o8Cwq+Qtmn35n5NOuo1XzcXaqMNfyMTvNvsO9DuWyDkcoC6KzQ1SQcjG6Ku+S Yemgxdu8fbXfHyi7wOfg7mnAuvLwxhSoTb3NLqIh8For5RD+6C1s6UNsnSyoNkd8j0eCwQ8te Lg9Zd5RdsGeGO1Nmn7MnD0/PA9zgRC8UfwGI15jyd1YQ9OseWoJ2qgHDNHc55g87dJIn5UaCy GQvsWfNEHHaB+bGjAKcLTYSnn5YYCvkZ+Qi46J5IANEf0iB/Mks+r8j0LvXgwmxLzzHBSIJ5I FJioo1BsNEX3hwC3SiatrfQg3axCxlqWU4jHcT7zyigfq2QGEKi+hD25EvMQZfsFDg0j4j8Qp rlylrkoyaiWr4xwd+kDjp2p3RXMUJm7bNvRdXdq9iCh/Sf8zBjp18WNGsxDoSbNxUdIXEbh/d fKcFRd/AZ+Hib3ZB3dXrF8sSNOXFplUIf/00sH1qxKmbSzQrW4fyzo6fWeqis7Ku3+FEVP5IJ UNe57rIkA3fFj6Qt5hS9luAreb+m6kyhAe39Jm9RjEpWqZTc6+cA+XUmqRNrKps0pKsZNdflO jzj3ODnGoa8esx4dBD4uqQy5jhKIUpsCh72tGXXRpOm4saOsiUI5rXHWBfE= X-Rspamd-Queue-Id: 67A418F9F9 X-Spamd-Bar: +++++ Authentication-Results: mx1.freebsd.org X-Spamd-Result: default: False [5.12 / 15.00]; RCVD_VIA_SMTP_AUTH(0.00)[]; HAS_REPLYTO(0.00)[freebsd@edvax.de]; TO_DN_SOME(0.00)[]; MV_CASE(0.50)[]; HAS_ORG_HEADER(0.00)[]; MX_GOOD(-0.01)[mx00.schlund.de,mx01.schlund.de]; RCPT_COUNT_TWO(0.00)[2]; RECEIVED_SPAMHAUS_PBL(0.00)[221.34.12.178.zen.spamhaus.org : 127.0.0.11]; RCVD_TLS_LAST(0.00)[]; R_DKIM_NA(0.00)[]; ASN(0.00)[asn:8560, ipnet:217.72.192.0/20, country:DE]; MIME_TRACE(0.00)[0:+]; FROM_EQ_ENVFROM(0.00)[]; ARC_NA(0.00)[]; REPLYTO_EQ_FROM(0.00)[]; FROM_HAS_DN(0.00)[]; NEURAL_SPAM_SHORT(0.60)[0.597,0]; MIME_GOOD(-0.10)[text/plain]; DMARC_NA(0.00)[edvax.de]; AUTH_NA(1.00)[]; NEURAL_SPAM_MEDIUM(0.82)[0.821,0]; TO_MATCH_ENVRCPT_SOME(0.00)[]; NEURAL_SPAM_LONG(1.00)[0.999,0]; MID_CONTAINS_FROM(1.00)[]; RCVD_IN_DNSWL_NONE(0.00)[74.192.72.217.list.dnswl.org : 127.0.5.0]; R_SPF_NA(0.00)[]; RCVD_COUNT_TWO(0.00)[2]; IP_SCORE(0.32)[ip: (-0.93), ipnet: 217.72.192.0/20(0.12), asn: 8560(2.40), country: DE(-0.01)] X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 13 Jul 2019 18:27:41 -0000 On Sat, 13 Jul 2019 03:31:17 -0600, @lbutlr wrote: > > > > On 12 Jul 2019, at 18:30, David Christensen wrote: > > > > On 7/12/19 11:12 AM, Robert Fitzpatrick via freebsd-questions wrote: > >> When I use the following command, I get packages with timestamp installed in epoch Unix time. Is there any way to format that date into month, day and year? > >> pkg query %n-%t > > > > Here's a Perl one-liner: > > > > 2019-07-12 17:28:52 dpchrist@cvs ~ > > $ pkg query %n-%t | perl -ne '/(.+)-(\d+)$/; ($d,$m,$y)=(localtime $2)[3,4,5];$y+=1900; printf "%-50s %4i-%02i-%02i\n", $1, $y, $m ,$d' > > bash 2019-01-21 > > cvs 2019-01-21 > > gettext-runtime 2019-01-21 > > > > I tried to add a | sort -k 2, thinking that would sort the output > by date, but while it changed the order of the output (no other > number did), it wasn’t based on the date column. Not sure what > it was based on. > > I also tried -k 2,4 and -k 2 -k 3 > > I assume I am missing something bloody obvious. In the formatting rule of the perl printf command, put a delimiter, for example "/": "%-50s/%4i-%02i-%02i\n", then use "| sort -t '/' +1" or "| sort -g -t '/' +1". ISO dates are sortable by definition. This should sort by the _2nd_ column with the defined delimiter. Or, probably much easier, change the printf command to create output as " " instead of the example providing " ", and just send this to "| sort". -- Polytropon Magdeburg, Germany Happy FreeBSD user since 4.0 Andra moi ennepe, Mousa, ...