SELECT Timestamp2-Timestamp1 AS Duration
FROM MyTable

---

 Comments and Workarounds

---

The workaround is to simply cast the result as a specific day-time interval like this:

CAST(Timestamp2-Timestamp1 AS INTERVAL DAY TO MSECOND)

---

 Resolution

---

Fixed Problem on 2/28/2007 in version 1.01 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