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

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

    XMLWordPrintableJSON

Details

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

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: