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

Unable to convert Opsgenie ack time from unix timefield to datetime field

I am struggling on converting opsgenie alert ack time from unix timestamp to datetimestamp. as it differ for each alerts differently.

Unix timestamp ranges from 8 to 10 character but in opsgenie it not consistent. Can you please help!

I am working on fetching data from opsgenie to PowerBI.  

1 answer

1 accepted

0 votes
Answer accepted

Hi @Ajaykumar Panchal !


The reporting fields of an alert (ackTime, closeTime, etc.) are relative and is measured in milliseconds since the alert was created. This is meant to agree with the unix-milliseconds timestamp used for absolute timestamps elsewhere in the application.


So an ackTime of 10000 would convert to 10s after the alert was created.


Hope this helps!

Thanks for your reply!! can you please help lets say I want to convert acktime into datetime format? How can I achieve it.

Robert Atlassian Team Sep 15, 2020

@Ajaykumar Panchal You would want to add that ackTime duration to the createdAt value returned in the API.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Opsgenie

Leveraging Atlassian’s Opsgenie and AWS Cloudformation Registry to stay ahead of incidents

In the past, managing IT infrastructure was a hard job. It required a lot of manual effort and it was hard to keep track of all the necessary information (monitoring, scalability etc). Thankfully, as...

2,427 views 0 13
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