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