Icon View Incident Report

Serious Serious
Reported By: Michael Fullerton
Reported On: 5/27/2007
For: Version 1.03 Build 1
# 2355 Using 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'

Resolution Resolution
Fixed Problem on 5/29/2207 in version 1.04 build 1

Products Affected Products Affected
ElevateDB 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