[DERBY-9] Documentation Bug

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.0.2.0
• Fix Version/s: 10.0.2.1
• Component/s: Documentation
• Environment: Windows 2K
• Assignee: Jean T. Anderson
• Reporter: Ali Demir
• Created: 28/Sep/04 19:16
• Updated: 06/Jun/05 01:17
• Resolved: 10/Nov/04 04:52

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.