Login
Products
Sales
Support
Downloads
About
Home
»
Technical Support
»
DBISAM Technical Support
»
Incident Reports
»
Incident Reports Addressed for Version 1.14
»
View Incident Report
View Incident Report
Serious
Reported By: John Dinning
Reported On: 4/4/1999
For: Version 1.13 Build 1
# 399
Subtraction of TimeStamp Fields Not Working in SQL Statements
The error:
DBISAME Engine Error #11949 SQL - type mismatch between column
'TXN_END_TIME' and column 'TXN_START_TIME' source columns.
on the following line of ann SQL statement:
sum(TXN_END_TIME - TXN_START_TIME) as TOTAL_TIME,
Both TXN_END_TIME and TXN_START_TIME are of type TimeStamp.
Resolution
Fixed Problem on 4/15/1999 in version 1.14 build 1
More Support Options
Search Incident Reports
Support Forums
Frequently Asked Questions
Technical Bulletins
Technical Articles
Product Manuals
Roadmap