Helen Borrie wrote:

> Timestamp - timestamp gives you a result in DAYS So you need to
> convert your comparison operand to seconds to match what it is being
> compared to:
>
> SELECT * FROM CALLSTAT
> WHERE CALLSTART>'2007-09-21 08:00:00:00.0000'
> AND (86400 * (CALLANSWER-CALLSTART)) < 10;
>
> ./hb

Helen, this worked like a charm. Thank you very much. :o)

Regards,
Thomas