Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-908

YEAR,SECOND,MONTH, MINUTE, HOUR and DAY functions have incorrect information on durations.

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 10.1.1.0
    • Fix Version/s: 10.3.1.4
    • Component/s: Documentation
    • Labels:
      None
    • Urgency:
      Low

      Description

      All these functions in the reference manual have a sentence like:
      (this is from DAY)

      If the argument is a time duration or timestamp duration: The result is the day part of the value, which is an integer between -99 and 99. A nonzero result has the same sign as the argument.

      This can be removed since Derby does not support durations. Then the surrounding text probably needs re-work as it leaves only a single type of argument.

        Attachments

        1. docChanges.diff
          8 kB
          Bryan Pendleton
        2. rrefdayfunc.html
          3 kB
          Bryan Pendleton
        3. rrefhourfunc.html
          3 kB
          Bryan Pendleton
        4. rrefminutefunc.html
          3 kB
          Bryan Pendleton
        5. rrefmonthfunc.html
          3 kB
          Bryan Pendleton
        6. rrefsecondfunc.html
          4 kB
          Bryan Pendleton
        7. rrefyearfunc.html
          3 kB
          Bryan Pendleton
        8. docChanges_v2.diff
          8 kB
          Bryan Pendleton
        9. rrefdayfunc.html
          3 kB
          Bryan Pendleton
        10. rrefhourfunc.html
          3 kB
          Bryan Pendleton
        11. rrefminutefunc.html
          3 kB
          Bryan Pendleton
        12. rrefmonthfunc.html
          3 kB
          Bryan Pendleton
        13. rrefsecondfunc.html
          3 kB
          Bryan Pendleton
        14. rrefyearfunc.html
          3 kB
          Bryan Pendleton
        15. docChanges_v3.diff
          9 kB
          Bryan Pendleton
        16. rrefsecondfunc.html
          3 kB
          Bryan Pendleton
        17. docChanges_v4.diff
          10 kB
          Bryan Pendleton
        18. rrefdayfunc.html
          3 kB
          Bryan Pendleton
        19. rrefhourfunc.html
          3 kB
          Bryan Pendleton
        20. rrefminutefunc.html
          3 kB
          Bryan Pendleton
        21. rrefmonthfunc.html
          3 kB
          Bryan Pendleton
        22. rrefsecondfunc.html
          3 kB
          Bryan Pendleton
        23. rrefyearfunc.html
          3 kB
          Bryan Pendleton
        24. minuteExample.diff
          0.8 kB
          Bryan Pendleton
        25. rrefminutefunc.html
          3 kB
          Bryan Pendleton

          Activity

            People

            • Assignee:
              bryanpendleton Bryan Pendleton
              Reporter:
              djd Daniel John Debrunner
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: