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

support for JQL queries to second resolution on datetime fields.

    XMLWordPrintable

Details

    • Suggestion
    • Resolution: Unresolved
    • None
    • JQL
    • None
    • 3
    • 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

      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

          Activity

            People

              Unassigned Unassigned
              4450a5665bb3 Tony Rice
              Votes:
              13 Vote for this issue
              Watchers:
              8 Start watching this issue

              Dates

                Created:
                Updated: