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
Another reason for not trying to read the database for Jira reporting, it is simply not built for it.
Anyway, you'll need to use whatever it is your SQL server uses to convert dates into a human format.
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.
from_unixtime(end_date/1000)
It looks like you're new here. Sign in or register to get started.
