View Incident Report

Minor

Reported By: Jeremy Martin
Reported On: 1/6/2005
For: Version 4.16 Build 1

# 1940 Using Date/Time/Timestamp Constant As First Argument to BETWEEN and IN Operators in SQL Causes Error

The following SQL statement generates the error:

#11949 SQL parsing error - Expected NULL, FixedChar, GUID, String,
Memo, or BLOB expression but instead found startdate in SELECT SQL
statement at line 2, Column 26

select * from placemnt where key = 'MURPHYJORD'
and '2005-01-06' between startdate and enddate

Comments and Workarounds

The workaround is to specifically CAST() the date/time/timestamp constant like this:

CAST('2005-01-06 AS DATE) BETWEEN StartDate AND EndDate

Resolution

Fixed Problem on 1/6/2005 in version 4.17 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap