Change the custom field format

Sugandha

I am using JIRA server 7.2.9

 

I have one date and time picker custom field " Go-live date", and I want to change the format of this field from date and time picker to just date picker.

Can someone help me on this and let me know if we can do this and if yes, then what is the process.

 

Nic Brough -Adaptavist-

You can't change field formats in the UI, the only way to do it is by amending the database.

You will need to be very careful if you do this, as database updates often completely wreck a Jira as most people don't understand the database well enough to do it properly.

In this case, the process would be:

• Stop Jira
• Backup the database in full
• Run some SQL that would
• Change every time in the field to 00:00:00.00
• Change the custom field header from date/time to date only field type
• Restart Jira
• Change the field "searcher" to "none", save it, then go back and change it to the one you want to use (you might not need to do this if the searcher is already correct)
• Re-index it