What is the format (internal layout) of ?TIMESTAMP??
- 1 Answers
- 4976 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How to view db2 table structure?
What is a trigger in the db2 database?
What is a dbrm in db2?
What is bind plan?
What is ibm db2 client?
What is the physical storage length of timestamp data type?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Explain how can you do the explain of a dynamic sql statement?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Are views updateable?
Which are the db2 tools to protect integrity of the database?
How to run db2 command in windows?
What is explain plan in db2?
What is db2 catalog database?
