Date time information saved in Jira Database for transitions

Question

Hi All,

I have created an issue in Jira.Based on the date and time the Created Field is updated.This field takes system date and time.

Now I am updating the issue from one status to another and in the transitions I can see both Date and time are displayed.

I am trying to search for this issue in my Jira Database JiraIssue table and changegroup table, when I see the created column the data has only date information.It does not contains time information.

Could you please help me if this information is saved somewhere in database or direct to correct database tables or a way to retrieve this date and time information from database.

MR2001 · Answer

I know it's late, as the posting is from 2019, but I can provide an answer (I experienced the same issue).

Just run this command before running the SELECT query and you will see date and time information for [Created] field:

alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS';

Regards,

M. R.

Nic Brough -Adaptavist- · Answer

>Was this changed in the recent releases?

No, it has not changed since Jira 1

>Is there some other table which I could join to my query to retrieve details related to date and time both?

No, because, as I said before, the data is stored in the tables you are reading, and there is no reason to duplicate it elsewhere.  The date and time you are pointing to in the change history in your screenshot is the date/time stored in the changegroup date/time field.

I do not know why your database tool is suppressing the time display.  Mine does not.  A changegroup in my Jira (was 7.6, now 8.0) looks like this:

Mehak Aggarwal · Answer

Is there some update on the issue?

Thanks,

Mehak