From database can we change issue creation date

[Softwares]

From database can we change issue creation date

[Nic Brough -Adaptavist- · Accepted solution]

Yes, but do not do it.

If you want to capture a "date issue happened", rather than the actual issue creation date, you should do that with a custom field that you ask the person or process entering the issue

The create date should remain "date/time we put the issue in Jira", which is a different informational point.

If you insist on destroying the creation date with SQL, then you will need to

1. Stop Jira
2. Take a full back up of the database
3. Make your SQL changes
4. Restart Jira
5. Run a full, locking re-index before any users get in
6. (Bear in mind that you are now unsupported, as SQL amendments to do anything other than repair data are not supportable)

[Joe Pitt]

Do not directly update the database for any reason. It is the path to destroying your JIRA instance.