Change the date and time of creation and updated tasks

How, using their administrative privileges can I change these values?

3 answers

I changed it using SQL in JIRA4.3.4 running against Oracle 11g.

Update involves jiraissue and jiraaction tables, updated separately, as below.

update jiraissue set created=<new created date> where <issue to be updated>

update jiraaction set created=<new created date> where ID = (select action.id from jiraaction action, jiraissue issue where actiontype='comment' and action.issueid = issue.id and <issue to be updated>

Ahmad Danial Atlassian Team May 15, 2013

Hey there, Kailash.

Thank you for sharing! Really appreciate it.

Warm regards,

Danial

1 votes
Ahmad Danial Atlassian Team May 14, 2013

Hey there, Ilia.

I believe that there is no way of altering these dates via JIRA UI itself. The thing that you might consider is to alter the values via the database from the jiraissue table via the created and updated columns.

Hope this helps.

Warm regards,

Danial

Thank you very much. I use these variants

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,906 views 12 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot