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



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

Answer / sadiq afroze

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

Is This Answer Correct ?    16 Yes 1 No

Post New Answer

More DB2 Interview Questions

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,


in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records

2 Answers   IBM,


DB2: A calls B once sucessfull and second time when it calls says curson is open why is it so?

1 Answers   IBM,


What is a DB2 catalog?

2 Answers  


why we go for SPUFI for creating tables or for sql queries?

4 Answers  






What are leaf pages?

3 Answers  


Which one allows duplicate values Union or Union All ?

3 Answers  


What is universal database?

0 Answers  


what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)

4 Answers   IBM,


how to resolve -811 error. give clear explination

4 Answers   IBM,


How can the duplicate values be eliminated from db2 select?

0 Answers  


How to check last update on table in db2?

0 Answers  


Categories