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

How Plan is created while executing the query using SPUFI?

3 Answers  


What are catalog tables in db2?

0 Answers  


what is different three logs in DB2?

1 Answers   Syntel,


What do you need to do before you do EXPLAIN ?

1 Answers  


i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?

4 Answers  


What is the difference between Where and Having Clause

7 Answers   IBM, iFlex,


How to restart a DB2 program?

0 Answers   Cognizant,


What are the contents of a dclmgen?

0 Answers  


In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,


What is the maximum size of varchar data type in db2?

0 Answers  


What is the use of db2?

0 Answers  


How to run db2 command in windows?

0 Answers  


Categories