What is the format (internal layout) of ?TIMESTAMP??



What is the format (internal layout) of ?TIMESTAMP??..

Answer / s

yyyy mm dd hh mm ss nnnnnn
2 + 1 + 1 +1+ 1+ 1+ 3 = 10
Internal representation of TIMESTAMP is a string of 10
bytes. One byte for two packed decimal digits.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More DB2 Interview Questions

What language is db2 written in?

0 Answers  


What is the meaning concurrency in the db2 database?

0 Answers  


How many buffer pools are there in DB2?

2 Answers  


What is correlated subquery?

1 Answers  


Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  






What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.

3 Answers   IBM,


How to find last record before record through SQLRPGLE?

1 Answers   IBM,


What is meant by index cardinality?

2 Answers  


Can I use LOCK TABLE on a view?

1 Answers  


How do you eliminate duplicate values in db2?

0 Answers  


i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error

3 Answers   UST,


What are simple, segmented and partitioned table spaces ?

1 Answers   TCS,


Categories