Icon View Incident Report

Serious 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 Resolution
Fixed Problem on 4/15/1999 in version 1.14 build 1
Image