Date: Sat, 13 Jul 2019 03:31:17 -0600 From: "@lbutlr" <kremels@kreme.com> To: freebsd-questions@freebsd.org Subject: Re: pkg query timestamp format Message-ID: <5343D197-AF3A-490E-AB75-F0624A77A3FE@kreme.com> In-Reply-To: <e2771f34-b0fe-5c09-dc8b-b2d549fdacbf@holgerdanske.com> References: <5D28CD7B.40102@webtent.org> <e2771f34-b0fe-5c09-dc8b-b2d549fdacbf@holgerdanske.com>
next in thread | previous in thread | raw e-mail | index | archive | help
> On 12 Jul 2019, at 18:30, David Christensen = <dpchrist@holgerdanske.com> wrote: >=20 > 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 >=20 > Here's a Perl one-liner: >=20 > 2019-07-12 17:28:52 dpchrist@cvs ~ > $ pkg query %n-%t | perl -ne '/(.+)-(\d+)$/; ($d,$m,$y)=3D(localtime = $2)[3,4,5];$y+=3D1900; printf "%-50s %4i-%02i-%02i\n", $1, $y, $m ,$d' > bash 2019-01-21 > cvs 2019-01-21 > gettext-runtime 2019-01-21 > <snip> 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=E2=80=99t 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. --=20 Yeah, Nick. Nick's the kinda guy you can trust. Nick's your buddy Nick's the kinda guy you drink beers with. The kinda guy that doesn't care if you puke in his car. Nick.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?5343D197-AF3A-490E-AB75-F0624A77A3FE>