Reported By: Michael Fullerton Reported On: 5/27/2007 For: Version 1.03 Build 1
# 2355Using BETWEEN with TIMESTAMP Column and DATE Constants Causes Compilation Error If you have a table with a timestamp field you can't seem to use a BETWEEN query with dates, only timestamps. When I run a query like the following, I get:
ElevateDB Error #700 An error was found in the statement at line 1 and column 48
(Expected Timestamp expression but instead found DATE '2007-02-15')
select * FROM MyTable
WHERE MyTimeStampField BETWEEN DATE '2007-02-15'
and DATE '2007-05-17'
ResolutionFixed Problem on 5/29/2207 in version 1.04 build 1
Products AffectedElevateDB Additional Software and Utilities ElevateDB VCL Client-Server ElevateDB VCL Client-Server with Source ElevateDB VCL Standard ElevateDB VCL Standard with Source ElevateDB VCL Trial