Message: A new issue has been created in JIRA.
--------------------------------------------------------------------- View the issue: http://issues.apache.org/jira/browse/DERBY-9 Here is an overview of the issue: --------------------------------------------------------------------- Key: DERBY-9 Summary: Documentation Bug Type: Bug Status: Unassigned Priority: Minor Project: Derby Components: Documentation Versions: 10.0.2.0 Assignee: Reporter: Ali Demir Created: Tue, 28 Sep 2004 12:16 PM Updated: Tue, 28 Sep 2004 12:16 PM 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. --------------------------------------------------------------------- JIRA INFORMATION: This message is automatically generated by JIRA. If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa If you want more information on JIRA, or have a bug to report see: http://www.atlassian.com/software/jira
