Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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
Answer accepted
Bruno Atlassian Team Aug 11, 2015

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.


Bruno Atlassian Team Aug 18, 2015

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
Published in Apps & Integrations

🍻🍂Apptoberfest Update: Upcoming Virtual Events 🎉

Hello Community! I hope you've been enjoying the 🍂Apptoberfestivities🍂 (I know I have!) The event is heating up next week with a series of virtual events that we're calling the 🍻🍂Partner App ...

65 views 0 5
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you