What is the format (internal layout) of "TIMESTAMP"?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What is the format (internal layout) of "TIMESTAMP"?

This is a seven part value that consists of a date (yymmdd) and time (hhmmss and microseconds).

(Continued on next question...)

Other Interview Questions

• What is the FREE command?
• When can an insert of a new primary key value threaten referential integrity ?
• What information is contained in a SYSCOPY entry?
• What are the Maximum and minimum, number of partitions allowed in a partition tablesspace?
• What is SPUFI?
• What is a clustered index?
• How does one remove entires from the SCT02 table?
• How to see the structure of DB2 table?
• When is the results table for the query in a DECLARE CURSOR statement created ?
• What technique is used to retrieve data from more than one table in a single SQL statement?
• More...