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

"Start date" / "End date" customfield timestamp logic

NIKHU
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 19, 2023

Hi Atlassians, 

There are customfields "Start date"/ "End date" enabled in jira project. To select values for these fields Calendar Picker is used. It allows to select date but not exact timestamp, however in Jira DB these fields are stored as timestamps with a random time (correct me if I'm wrong).
Could you please describe the logic of timestamp for these field being generated (time part of timestamp)?
Thank you in advance!

1 answer

0 votes
Trudy Claspill
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
September 19, 2023

Hello @NIKHU 

Welcome to the Atlassian community.

How did you determine that a random time is being added to the data in the database?

If the Start date and End date fields are presenting only a Calendar for selecting a value, then they are Date Picker fields and the time information is irrelevant.

NIKHU
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 19, 2023

p2.PNGp3.PNG

With date picker user is not allowed to select time part to the value, but time is added automatically on backend side. And it is not the same for different issues (but in most cases time is set to 22:00, 23:00 or 00:00)

p4.PNGp5.PNG

 

I agree that time is irrelevent for this field, but just want to fully comprehend behavior of these fields.
Thank you!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events