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 types of tables are there in the db2 database?

0 Answers  


What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,


Once you create a view, where would information about the view be stored?

1 Answers  


how to resolve -805. give clear explination for that

2 Answers   IBM,


How to view db2 table structure?

0 Answers  






What is an alias and how does it differ from a synonym?

3 Answers  


For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?

2 Answers   iGate,


Explain how can you do the explain of a dynamic sql statement?

0 Answers  


What is load utility in db2?

0 Answers  


what is difference between Plan and Package

1 Answers   Syntel,


Can we declare DB2 HOST variable in COBOL COPY book?

2 Answers  


When will you chose to run RUNSTATS?

1 Answers  


Categories