Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.0.2.0
    • Fix Version/s: 10.0.2.1
    • Component/s: Documentation
    • Labels:
      None
    • Environment:
      Windows 2K

      Description

      reference.pdf: page 178

      Tests whether the first operand is between the second and third operands. The second operand must be less than the third operand. Applicable only to types to which <= and >= can be applied. WHERE booking_date BETWEEN DATE'1998-02-26' AND DATE'1998-03-01'

      Syntax does not work. DATE'1998-02-26' i think is wrong.

      WHERE booking_date BETWEEN '1998-02-26' AND '1998-03-01'

      seems to work.

        Activity

          People

          • Assignee:
            Jean T. Anderson
            Reporter:
            Ali Demir
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development