Uploaded image for project: 'Jira Platform Cloud'
  1. Jira Platform Cloud
  2. JRACLOUD-31250

Allow JQL querying down to the second on all date fields

XMLWordPrintable

    • Icon: Suggestion Suggestion
    • Resolution: Won't Fix
    • None
    • None
    • Our product teams collect and evaluate feedback from a number of different sources. To learn more about how we use customer feedback in the planning process, check out our new feature policy.

      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.

              Unassigned Unassigned
              468d4a2c90d7 David Mahoney
              Votes:
              1 Vote for this issue
              Watchers:
              8 Start watching this issue

                Created:
                Updated:
                Resolved: