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

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

8336


What is nvl in db2?

827


What is collection in db2 bind?

778


Following a db2 update statement, what is the quickest way to compute the total number of updated rows?

835


How do I optimize a query in db2?

831


How to find primary key of a table in db2?

815


What does runstats do in db2?

775


What is syscat in db2?

781


Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

2910


What is runstats utility in db2?

767


When the like statement is used?

890


How do you select a row using indexes in db2?

853


How will you return the number of records in table?

713


What is load replace in db2?

756


List down the data types in the db2 database.

816