db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From derby-...@db.apache.org
Subject [jira] Created: (DERBY-9) Documentation Bug
Date Tue, 28 Sep 2004 19:17:32 GMT
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


Mime
View raw message