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

Answer Posted / sadiq afroze

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

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain in brief how does db2 determine what lock-size to use?

599


What is the cobol picture clause of the db2 data types date, time, timestamp?

619


What is the reason behind not using select * in embedded sql programs?

603


How do I delete a table in database?

599


Why db2 is called db2?

595






What is db2 purescale?

551


What is lock escalation in db2?

574


Which is faster delete or truncate?

681


List out the three types of page locks that can be held.

689


Before you give the explain statement, what are the prerogatives?

581


Name the lockable units in DB2?

665


Mention a credible reason why select* is never given preference in an sql program that has been embedded.

720


What is the difference between oracle and db2?

587


What is null value in db2?

567


List down the data types in the db2 database.

636