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

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

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

Atlassian Community Events