How can I include the date a sprint was closed in query outcomes?

[Shane Wright]

I need to be able to find the date a sprint was resolved as a part of various queries I need to right. I can find closed sprints and the issues in them, but not the date the sprint was closed. Any and all advice much appreciated.

[Andy Heinzer · Accepted solution]

Jira Software is storing the sprint start/stop times in the unix epoch format.  It's also doing this in the "AO_60DB71_SPRINT" table of the Jira database.

So you can certainly run a SQL query of

SELECT "CLOSED", "COMPLETE_DATE", "END_DATE", "GOAL", "ID", "NAME", 
       "RAPID_VIEW_ID", "SEQUENCE", "STARTED", "START_DATE"
  FROM "AO_60DB71_SPRINT";

in order to see the start_date and end_date.  The problem with that is you then have to find a way to convert these unix time stamps into something a human can read.  Perhaps there is a cast parameter you can use to convert these, however I'm not sure the specific syntax to do that.   I know you can use a site like the EpochConverter if that helps.