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- · Accepted solution]

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

[Bob]

Alternative would of course be to create a new custom field and copy / import the data from the existing field to it. 

Unless there's a big reason making this not an option, this seems preferable.