Derby
  1. Derby
  2. DERBY-4106

The Reference Gulde claims that the INTEGER function can be applied to dates and times

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.4.2.0
    • Fix Version/s: 10.6.1.0
    • Component/s: Documentation
    • Labels:
      None
    • Environment:
      MS Windows XP Professional Version 2002 Service Pack 2, running NetBeans IDE 6.5
    • Urgency:
      Normal

      Description

      When Derby Reference Manual, version 10.4, explains the INTEGER function is said that:

      "The INTEGER function returns an integer representation of a number, character string,
      DATE, or time in the form of an integer constant"

      But when I try to convert a DATE to INTEGER I receive an sqlstate 42846: "Cannot convert types 'DATE' to 'INTEGER'."

      This is a sample query where the expected result is the integer number 1:

      select integer(date(1)) from SYSIBM.SYSDUMMY1

      1. docs.diff
        0.8 kB
        Bryan Pendleton
      2. rrefbuiltinteger.html
        4 kB
        Bryan Pendleton

        Issue Links

          Activity

          Gavin made changes -
          Workflow jira [ 12457043 ] Default workflow, editable Closed status [ 12800073 ]
          Kathey Marsden made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Bryan Pendleton made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 10.6.0.0 [ 12313727 ]
          Resolution Fixed [ 1 ]
          Bryan Pendleton made changes -
          Attachment docs.diff [ 12424309 ]
          Attachment rrefbuiltinteger.html [ 12424310 ]
          Bryan Pendleton made changes -
          Assignee Bryan Pendleton [ bryanpendleton ]
          Rick Hillegas made changes -
          Summary The INTEGER function doen't return an integer representation of a date The Reference Gulde claims that the INTEGER function can be applied to dates and times
          Rick Hillegas made changes -
          Component/s Documentation [ 11406 ]
          Component/s SQL [ 11408 ]
          Rick Hillegas made changes -
          Urgency Normal
          Dag H. Wanvik made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-4107 [ DERBY-4107 ]
          Nelson Rodrigues created issue -

            People

            • Assignee:
              Bryan Pendleton
              Reporter:
              Nelson Rodrigues
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development