Differences between DB2 TimeStamp and TIME

SELECT

Current

Time

AS

TTIME,

Current

Timestamp

AS

TTIMESTAMP

From

TTTT; Results: TTIME TTIMESTAMP16: 26: 44 2004-11-5 16: 26: 44.147000Time only three steps, TTIMESTAMP is seven