Uploaded image for project: 'Pentaho Reporting and Pentaho Report Designer'
  1. Pentaho Reporting and Pentaho Report Designer
  2. PRD-5499

MINUTES() of a value with seconds >= 30 returns correct_value+1

    XMLWordPrintable

    Details

    • Story Points:
      0
    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.
    • Sprint Team:
      Maintenance
    • Steps to Reproduce:
      Hide

      let v be a time (or date+time) value whose seconds are 30 or more, e.g. 23:11:43

      MINUTES(v) returns 12, but should return 11

      Show
      let v be a time (or date+time) value whose seconds are 30 or more, e.g. 23:11:43 MINUTES(v) returns 12, but should return 11

      Description

      That's because MINUTES computes a FRACTIONAL amount of minutes and then rounds it instead of truncating it.

      The attached patch fixes that.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              wfaulkner William Faulkner
              Reporter:
              lmamane Lionel Elie Mamane
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: