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

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

Question Posted / sadiq afroze

Answer Posted / sadiq afroze

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

Is This Answer Correct ?

17 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Explain about cursor stability?

1112

What is package in cobol db2?

1163

What is commit in db2?

1109

How to execute stored procedures?

1178

How do I delete a table in db2?

1126

How do you pull up a query which was previously saved in qmf?

1206

Which command is used to connect to a database in DB2 ? Give the Syntax.

1153

DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2912

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

3011

What are catalog tables in db2?

1109

How do I add a column to a table in db2?

1161

What is plan in cobol db2?

1207

What is the maximum number of columns in a db2 table?

1349

What is consistency token in db2?

1196

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

1178