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

How does one remove entries from the SCT02 table?

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM

Write a query to retrive partial string.

What is load replace in db2?

What are the advantages of using a PACKAGE?

How to find the maximum value in a column in the db2 database?

Which component is responsible for processing sql statements and selecting access paths?

where will u check for sqlcode ?

How does db2 sample database connect?

What is meant by AUTO COMMIT?

What is the difference between static and dynamic SQL?

For more DB2 Interview Questions Click Here