What is the physical storage length of each of the following DB2 data types: D

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

Question Posted / guest

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 ?

17 Yes

1 No

More DB2 Interview Questions

What is view db2?

What is universal database?

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?

What are the various locks available?

What is the usage of open cursor command?

What are catalog tables in db2?

What is the picture clause of the null indicator variable?

What is usage pointer in cobol?

In SPUFI suppose you want to select maximum of 1000 rows, but the select returns only 200 rows. What are the 2 SQLCODEs that are returned?

What is a trigger in the db2 database?

What is bind and rebind in db2?

what is the soft code for deadlock ?

For more DB2 Interview Questions Click Here