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

    • Icon: Suggestion Suggestion
    • Resolution: Unresolved
    • None
    • JQL
    • None
    • 1
    • 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.

      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.
       

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

            eskapesm added a comment -

            any news about this ?

            eskapesm added a comment - any news about this ?

            saikisho added a comment -

            We need this feature. Any update on this.

            saikisho added a comment - We need this feature. Any update on this.

            Nishant Kumar added a comment -

            We need this important feature.

            Jira team please work around it.

            Nishant Kumar added a comment - We need this important feature. Jira team please work around it.

            Tony Rice added a comment -

            This suggestion was rejected without comment from Atlassian 6 years ago and continues to receive customer support.

            Tony Rice added a comment - This suggestion was rejected without comment from Atlassian 6 years ago and continues to receive customer support.

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

                Created:
                Updated: