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

In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,


Can you tell me how can you find out the # of rows updated after an update statement?

1 Answers  


In a DB2-CICS program which is acts as co-ordinator and which is participant?

1 Answers   IBM,


How to resolve -818 sql code in DB2?

2 Answers   Cap Gemini,


Name some fields from SQLCA.

2 Answers  


What is a lock?

1 Answers  


what is rebinding ?

1 Answers   IBM,


What is copy pending status in db2?

1 Answers  


if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,


What is a predicate?

1 Answers  


Define declaration generator (dclgen).

1 Answers  


What is reorg in database?

1 Answers  


Categories