Mysql db query to get sprint start and end date in readable format currently they are in bigint

[Venkata Jaganmohana Harish Babu Vura Vura]

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

[Payne]

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)

[Nic Brough -Adaptavist-]

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.