What is the physical storage length of the data types: date, time, timestamp in the db2 database?



What is the physical storage length of the data types: date, time, timestamp in the db2 database?..

Answer / Yati Bajpai

"Date": 9 bytes. "Time": 5 bytes. "Timestamp": 14 or 22 bytes (depending on precision).

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

How to handle null values in db2

4 Answers  


What is the maximum length of sqlca?

1 Answers  


what is the name of the default db2 catalog database?

3 Answers   IBM,


What are the three lock types?

2 Answers  


what is sql abend code -801,-802?

2 Answers  


what is the soft code for deadlock ?

2 Answers   Logica CMG,


How many Buffer pools are there in DB2 and what are they?

1 Answers   IBM,


What is an access path?

3 Answers  


What is index in db2?

1 Answers  


why we create view.

5 Answers  


How many buffer pools are available in db2?

2 Answers  


What is the function of the Data Manager?

2 Answers  


Categories