View Incident Report

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

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

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

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap