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

how to copy the host variables from ps file into cobol program other than include statement

1 Answers   Syntel,


What is a clustered index?

1 Answers  


How can we define a table? How can we apply SEARCH ALL on it ?

1 Answers  


What is meant by explain?

0 Answers  


How can you split a table in to exactly half?

7 Answers   HSBC,






How to define the data items to receive the fetch items for the SQL?

2 Answers  


what is the difference between join and union?

4 Answers   IBM,


When is the access path determined for dynamic SQL?

2 Answers  


What language is db2 written in?

0 Answers  


What is the use of runstats in db2?

0 Answers  


Describe major components of db2?

0 Answers  


how to fetch first 100 rows in db2

2 Answers   IBM,


Categories