Date time information saved in Jira Database for transitions

[Mehak Aggarwal]

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.

[Nic Brough -Adaptavist- · Accepted solution]

It should work for all project types, but only in the plain Core issue view (i.e. looking at https://yourjira/browse/SD-42 for example)

[Paul Richard]

Thanks for the reply, but on my installation that view behaves the same in terms of the buttons. I only see 2 buttons and then the menu. Any other ideas?

Paul

[Nic Brough -Adaptavist-]

No, that's the way to change the number.  It's working fine on the installations I've done it to - are you sure have the right file, spelling of the property key and restarted your install?  (I usually managed to mis-spell properties when I'm trying to change them)

[Paul Richard]

I finally made my way back to this recently and quickly noticed my blunder last time. When creating the properties file, I failed to notice that the editor had automatically appended the .txt extension. Once I removed it, it worked as expected. I just thought I'd finally close this "open loop". Late thanks to Nic for your assistance!