Hello,

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.

Isnt TIMESTAMP format '2007-12-10.12.12.32.3234'?

I got my insert data rejected because of that.

What did i do wrong?

Thanks

M

Welcome to the forum


Moved to DB2 topic

Hi,
you have syntax error.

You can write:
2007-12-10-12.12.32.3234
or
2007-12-10-12.12.32.323400
but not like you wrote:
2007-12-10.12.12.32.3234

Hope this helps,
Grofaty

" 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).