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

Question Posted / guest

1 Answers
5718 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

How will fetch last 5 rows from table in db2

6 Answers

What is a system catalog table in db2?

0 Answers

What is a DBRM, PLAN ?

3 Answers

Can any one tell me about Restart logic in DB2.

2 Answers

What is cursor stability?

1 Answers

how to resolve -805. give clear explination for that

2 Answers IBM,

how to resolve -811 sqlcode .give clear explaination

3 Answers IBM,

Describe major components of db2?

0 Answers

What is the use of reorg in db2?

0 Answers

How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers Wipro,

insert into tablename a column1, column2 select column1, column2 from tablename b i am getting abend -104..can any one help?

3 Answers Syntel,

What is Declaration Generator(DCLGEN)?

1 Answers

For more DB2 Interview Questions Click Here