OBIEE Timestamp

TIMESTAMP 'YYYY-MM-DD HH24:MI:SS'

TIMESTAMP '1990-01-10 13:35:43'


Time stamp difference in obiee
I have two columns with TIMESTAMP data type(One is In time and the other is Outtime).The values are as below.
In Time Out Time
14-jan-08 1:40:45 AM 14-jan-08 1:30:45 PM
15-jan-08 3:22:53 PM 15-jan-08 5:23:54 PM
16-jan-08 3:20:50 PM 16-jan-08 4:23:54 PM
17-jan-08 3:13:44 PM 17-jan-08 7:23:54 PM
I need the out put as below

00:11:50:00
00:2:01:01
00:1:03:04
00:4:10:10


Solution:

CAST( TimestampDiff(SQL_TSI_DAY, timestamp1, timestamp2) AS CHAR(2)) || CAST( TimestampDiff(SQL_TSI_HOUR, timestamp1, timestamp2) AS CHAR(2)) || CAST( TimestampDiff(SQL_TSI_MINUTE, timestamp1, timestamp2) AS CHAR(2)) || CAST( TimestampDiff(SQL_TSI_SECOND, timestamp1, timestamp2) AS CHAR(2))