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

Question Posted / guest

1 Answers
5737 Views
I also Faced
E-Mail Answers

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

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 is declare cursor?

0 Answers

For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?

3 Answers

i have a db2 variable how do u declare tht into working storage section ?

1 Answers TCS,

When reorg is used?

0 Answers

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers UST,

Comment whether the cursor is closed during commit or not.

0 Answers

What is a system catalog table in db2?

0 Answers

Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?