date range search

Question

ON Atlassian JIRA (v5.2.11):

FOR JIRA Query:

I’m expecting search query to execute between “start time from 00:00:01hrs 13/june/2013 to 23:59:59hrs 17/june/2013” in JIRA using search params: created >= 2013-06-13 AND created <= 2013-06-17.

AND Outcome I’m expecting is all defects created from 00:00:01hrs 13/june/2013  until 23:59:59hrs 17th june 2013.But this is not the case, I'm getting all bugs created until the end of day 2013-06-16.

is my logic right .. let me know

mohammed Asif1 · Answer

thx and this is very usefull.

Florin Manaila4 · Answer

The behavior does make sense, since the date values provided use day-precision. Since the created date uses the time of day as well, following your logic, 2013-06-17 should be translated to different values depending on the comparator (< or >).

So IMHO, the current behavior is better since it provides some degree of consistency. Additionally, you might want to consider using jql functions like startOfDay() and/or endOfDay().