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

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,