Currently Sprint start date and end dates having datatype of big int , Is there any way to convert those into date format in jira mysql database
Nic is correct in that one shouldn't do too much direct database querying, but there are occasional times where it's useful.
In this case, the date is stored as a Unix timestamp in milliseconds, so use the from_unixtime() function and divide by 1000 (to get seconds), e.g.
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