Uploaded image for project: 'Jira Data Center'
  1. Jira Data Center
  2. JRASERVER-31250

Allow JQL querying down to the second on all date fields

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Won't Fix
    • None
    • None
    • None
    • We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

    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

          Suggestion - JRASERVER-70425 support for JQL queries to second resolution on datetime fields.

          • Gathering Interest
          is related to

          Suggestion - JRASERVER-32560 Allow LESS OR EQUAL operator in createdDate JQL to return all issues in the same day

          • Closed
          relates to

          Suggestion - JRACLOUD-31250 Allow JQL querying down to the second on all date fields

          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: