Details
-
Suggestion
-
Resolution: Won't Fix
-
None
-
None
-
None
Description
NOTE: This suggestion is for JIRA Server. Using JIRA Cloud? 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
- has a derivative of
-
JRASERVER-70425 support for JQL queries to second resolution on datetime fields.
- Gathering Interest
- is related to
-
JRASERVER-32560 Allow LESS OR EQUAL operator in createdDate JQL to return all issues in the same day
- Closed
- relates to
-
JRACLOUD-31250 Allow JQL querying down to the second on all date fields
- Closed