Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal


  • Give kudos
  • Received
  • Given


  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Why do the startdate and updated fields in the worklog table have same values? Edited

I'm working on this public JIRA database shared on this post

Is there a logical explanation for why the created, updated and startdate of the worklog table all have the same values for all the rows? Is it supposed to be this way or is it because it is a dummy data? Can you help me understand the differences between the three fields?

How can I find the start time and the end time of an issue for its issueid?

Also, what is the unit for the timeworked field in the worklog table?

Screenshot from 2020-01-03 15-38-21.png

1 answer

1 accepted

Hello @Siddhant Bane 

Each of those fields has a different purpose that is not too obvious at first, but becomes rather self explaning during usage.

Created Date

The Created Date shows you the point in time when this issue was created originally and is used throughout all jira applications as it belongs to Jira Core.

Updated Date

The Updated Date gets modified, whenever someone changes an issue. Therefore it shows the point in time, when this issue was last edited in any way. Like the created date it is a standard that is used throughout all jira applications.

Start Date

The Start Date is the point in time, when you plan to start work on your issue. It is mainly used within Portfolio for jira and by installing the app it will be added as custom field. I have never taken a look at it on a db level, but either it always holds a default value that remains hidden until modified, or it is was explicitally configured to receive a default value in your instance.

I hope that this was able to resolve some confusion. Have a happy new year and cheers,

Andrej from greenique

Thank you so much! This helps a lot.

Suggest an answer

Log in or Sign up to answer

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you