Joined: 20 Oct 2006 Posts: 6970 Location: porcelain throne
Why don't you check the manual?:
DB2 Vsn 8 SQL Reference wrote:
Subtracting timestamps: The result of subtracting one timestamp (TS2) from
another (TS1) is a timestamp duration that specifies the number of years, months,
days, hours, minutes, seconds, and microseconds between the two timestamps. The
data type of the result is DECIMAL(20,6).
further information can be obtained in the Application Programmers manual.