Community
Q&A
Jira
Questions
Mysql db query to get sprint start and end date in readable format currently they are in bigint

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

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

2 answers

Community moderators have prevented the ability to post new answers.

0 votes

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)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

0 votes

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.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.