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.













Here is the same table in the retrieved raw data:


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?



1 answer

1 accepted

0 votes
Accepted answer

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.



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.


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

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Monday in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

58 views 3 2
Join discussion

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