Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

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 does the RUNSTATS Utility do?

4 Answers  

How can you display the current date & current time ?

1 Answers   Cap Gemini,

Do we need cursor for Count(*)?

4 Answers   iGate,

How to get Top 10 Salaries from a Table

11 Answers   Accenture, HTC,

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

0 Answers  

Why might full image copies be faster to implement than an incremental image copy?

4 Answers  

what is sql abend code -801,-802?

2 Answers  

what is a corelated subquerry?

0 Answers   IBM,

Define sqlca.

0 Answers  

What is package versioning? Please give an example.

1 Answers  

How do I delete a table in database?

0 Answers  

what is difference between Static call and Dynamic call? How does it function?

1 Answers   Syntel,