Follow Our FB Page << CircleMedia.in >> 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,






Categories