Details
-
Suggestion
-
Resolution: Won't Fix
-
None
-
None
Description
NOTE: This suggestion is for JIRA Cloud. Using JIRA Server? See the corresponding suggestion.
Users who are familiar with mainstream SQL expect to be able to specify date fields down to the second.
We would like to be able to format JQL queries as follows:
createdDate >= "2013-01-11 00:00:00" and createdDate <= "2013-01-11 23:59:59"
We know that date data is stored in the database down to the second, as using createdDate <= "2013-01-11 23:59" excludes any issues created during the last minute of the day.
Attachments
Issue Links
- is related to
-
JRACLOUD-32560 Allow LESS OR EQUAL operator in createdDate JQL to return all issues in the same day
- Closed
-
JRASERVER-31250 Allow JQL querying down to the second on all date fields
- Closed