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

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

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    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. 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

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment