Re: [PLUG] date format

[jeff <jeffv@op.net>]

Thanks.
I was thinking to myself, what a great thing this would be if I could 
automate it (as I was copying and pasting). There's another column, so 
it's appreciated.


On 10/15/2018 01:46 PM, JP Vossen wrote:
> On 10/15/2018 12:24 PM, jeff wrote:
> > I have lots of backups from my old phone, so naturally none of the 
> > calendar backups work. I finally resigned myself to manual input, but 
> > even that didn't work.
> >
> > 1507075200000 is somehow 10/4/yyyy. Every date is like this.
> > It won't format to date, even chucking the leading 1 and/or trailing 
> > zeroes. It's almost like it's personal with these phones.
> >
> > Has anybody seen this before?
>
> As Jason pointed out that's an Epoch.  Here's something I wrote last 
> month for someone at $WORK with a similar need.  It's quite ugly 
> brute-force, but...it works.
>
> ----
> #!/bin/bash -
> # 2018-09-12: trivial Epoch converter wrapper
>
> echo "$1" | \
>    perl -ne 'use POSIX qw(strftime);
>      print "$1 = " ,
>        strftime("%Y-%m-%d %H:%M:%S %z\n", gmtime($1))
>          if m/^(\d{10}).*$/;'
> ----
>
> $ ./epoch.sh 1507075200000
> 1507075200 = 2017-10-04 00:00:00 -0400
>
> Adjust the strftime string (`man date`) as desired and wrap the rest in 
> a loop or something.  Or post a sample of the data/file format and I or 
> someone else can tweak to handle it.  Python does it cleaner, but I know 
> Perl and Perl does nice one-timers. :-)
>
> Contortions using GNU `date` will work too.  Chapter 11 of the _Bash 
> Cookbook_ is devoted to "Working with Dates and Times" and uses a lot of 
> GNU `date`.
>
> Later,
> JP
> --  -------------------------------------------------------------------
> JP Vossen, CISSP | http://www.jpsdomain.org/ | http://bashcookbook.com/
> ___________________________________________________________________________
> Philadelphia Linux Users Group         --        http://www.phillylinux.org
> Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
> General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug
___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug