Convert system time back to readable date

We had the tasklist plugin installed in our confluence instance, but after an upgrade (not sure from what but we skipped some version or other) to Confluence 5.6.6 it stopped working with a message of "unknown macro".

Using the "View Storage Format" option from the tools menu for the page I retrieved the data, and the put it in to the page using the wiki markup as the retrieved data was already in wiki markup format. Everything formats OK except the two date columns (CreatedDate, CompletedDate) that the tasklist mcro was using are showing what looks like a system date.

Completed

Priority

Locked

CreatedDate

CompletedDate

 

 

T

M

F

1389111643041

1413289850182

Here is the same table in the retrieved raw data:

||Completed||Priority||Locked||CreatedDate||CompletedDate||Assignee||Name||
|T|M|F|1389111643041|1413289850182|

Is there any way that I can get the system to convert these back to human readable dates, such as with a bit of wiki markup or similar?

 

Thanks

1 answer

1 accepted

0 vote

Hi Tom,

It seems that the dates are stored in Unix time. If you search for unix epoch batch converter you should be able to find converters on the web. But please notice that the timestamps in your file are in milliseconds; usually the unix time is given in seconds, so 1413289850182 would be something like 1413289850. I'm sure there are many ways of automating this for your specific case. I'll let you know if I come up with something better.

Regards,

Bruno

Thanks Bruno,

The moment has long since passed, but I easily managed to find a tool that would have helped, now that I know what the time format is called. I searched for unix "timestamp epoch batch converter" and had plenty of useful hits.

Tom

You're welcome, Tom. Yeah, I always keep these converters in my toolbelt. :P

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Feb 15, 2018 in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

1,131 views 6 19
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot