question how to read time reported by yarn in Archives of Support Questions (Read Only)

how to read time reported by yarn

aliyesami — Wed, 20 Jun 2018 22:45:35 GMT

how can I convert this start and finish time to normal date format?

$ yarn application -status application_1517871817099_0015
Application Report :
        Application-Id : application_1517871817099_0015
        Application-Name : distcp
        Application-Type : MAPREDUCE
        Queue : default
        Application Priority : null
        Start-Time : 1517874876754
        Finish-Time : 1517875501288
        Progress : 100%
        State : KILLED
        Final-State : KILLED

Re: how to read time reported by yarn

aliyesami — Wed, 20 Jun 2018 23:18:15 GMT

I found two methods online which gives different results , which one is correct ?

$ date -d @1517874876754
Tue Jul 16 02:12:34 EDT 50069

mysql> select from_unixtime(floor(1517875501288/1000));
+------------------------------------------+
| from_unixtime(floor(1517875501288/1000)) |
+------------------------------------------+
| 2018-02-05 19:05:01                      |
+------------------------------------------+

Re: how to read time reported by yarn

aliyesami — Wed, 20 Jun 2018 23:30:38 GMT

ok I found three ways to convert correctly the milliseconds unix time to human readable time format

mysql> select from_unixtime(floor(1517874876754/1000));
+------------------------------------------+
| from_unixtime(floor(1517874876754/1000)) |
+------------------------------------------+
| 2018-02-05 18:54:36                      |
+------------------------------------------+
1 row in set (0.00 sec)

$ awk '{print strftime("%c", ( 1517874876754 + 500 ) / 1000 )}'
Mon 05 Feb 2018 06:54:37 PM EST

$ date -d @$(  echo "(1517874876754+ 500) / 1000" | bc)
Mon Feb  5 18:54:37 EST 2018