" The length is 10." is for the internal binary format of timestamp. In another word, DB2 use 10 bytes to store a timestamp value. When display the value, the application and db2 usually show the string format which looks like '2007-....'. the string format takes 20 or so bytes(probably 26).
Originally Posted by darkyhorse
I am newbie.
I have create some tables and columns. One thing bug me is timestamp data type.
I use IBM DB2 Express-C.
I looked up the table with control centre to see what length the TIMESTAMP is. The length is 10.