Sprint start and end date are IDs

[Ian Cockcroft]

Hi guys, I’m trying to bring in the sprint start and end date from AO_60DB71_SPRINT in a SQL statement.

The date looks like an ID.

Any idea how, where I can get the actual date? How to use the ID

[Daniel Eads · Accepted solution]

Hi Ian,

The dates are actually in Unix Epoch format. There are a myriad of tools available for converting them into a human-readable format, but here are a couple that might be useful.

• Converting in-browser online (epochconverter.com)
• Doing it in Python
• Doing it in Javascript
• Casting the time to human readable formats in various SQLs

Cheers,
Daniel

[Ian Cockcroft]

Thanks Daniel,

I did find this

    TO_CHAR(TO_DATE('1970-01-01','YYYY-MM-DD') + s.start_date / 86400000,'YYYY-MM-DD')  "SPRINT START DATE",

seem to work

cheers