Windows 10, Emacs 26.1
In org file:
| _id | Date | expiresDate | amount |
|-----+---------------+---------------+----------|
| 633 | 1539190765000 | 1573336800000 | 766.26 |
| 184 | 1542045137000 | 1576101600000 | 851.4 |
| 110 | 1542348620000 | 1576447200000 | 936.54 |
| 634 | 1539190765000 | 1573336800000 | 40788.33 |
| 185 | 1542045137000 | 1576101600000 | 41041.81 |
| 7 | 1543213783000 | 1577311200000 | 41295.29 |
| 756 | 1538629706000 | 1573768800000 | 177.0 |
In columns "Date" and "expiresDate" dates are in milliseconds (from January 1, 1970, 00:00:00 GMT). E.g. 1539190765000 = 10.10.2018 16:59
I use this site for convert https://www.fileformat.info/tip/java/date2millis.htm
So I need to convert both dates columns to human readable format: YYYY-MM-dd HH:mm
So the result must be like this:
| _id | Date | expiresDate | amount |
|-----+--------------------+--------------------+--------|
| 633 | <2018-10-10 16:59> | <2019-11-19 22:00> | 766.26 |
...
How I can do this?