What is the format (internal layout) of ?TIMESTAMP??
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
What is syscat in db2?
Are view updateable?
Explain how can you do the explain of a dynamic sql statement?
Explain in detail about buffer manager and its functionalities?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is the physical storage length of the data types date, time, and timestamp?
What is catalog database in db2?
Explain correlated sub-queries.
Define declaration generator (dclgen).
What is the difference between db2 and oracle?
What is dbrm? What it contains? When it will be created?
What is the use of value function?
what are bind concepts in db2 cobol?
What is check constraint. Explain with example.
What is coalesce in db2?