DATE: 4bytes TIME: 3bytes TIMESTAMP: 10bytes

What is the physical storage length of each of the
following DB2 data types: DATE, TIME, TIMESTAMP?

Question Posted / sadiq afroze

Answer Posted / sadiq afroze

DATE: 4bytes
TIME: 3bytes
TIMESTAMP: 10bytes

Is This Answer Correct ?

17 Yes

1 No

Please Help Members By Posting Answers For Below Questions

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1100

Explain about dbrm.

1037

What is the picture clause of null indicator variable?

1132

Is it possible using max on a char column?

1134

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1182

What is difference between rollback and commit?

1153

What is the role of data manager in the db2 database?

1099

What is the syntax for creating a table in the db2 database?

1102

What is the difference between cursor and select statement?

1094

What is a trigger in the db2 database?

1067

How do you select a row using indexes in db2?

1130

How to find primary key of a table in db2?

1057

What is copy pending and check pending in db2?

994

What are types of indexes?

1063

What is the default page size of buffer pools?

1120