Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the three DB2® Database date and time data types and their associated functions?

April 26, 2017associated Data database functions time types

0

Posted

What are the three DB2® Database date and time data types and their associated functions?

1 Answer

0

Posted

A228) The three data types are DATE, TIME and TIMESTAMP. CHAR can be used to specify the format of each type. The DAYS function calculates the number of days between two dates. (It’s Y2K compliant). Q229) Explain transactions, commits and rollbacks in DB2® Database. A229) In DB2® Database a transaction typically requires a series of updates, insertions and deletions that represent a logical unit of work. A transaction puts an implicit lock on the DB2® Database data. Programmers can use the COMMIT WORK statement to terminate the transaction creating smaller units for recovery. If the transaction fails DB2® Database uses the log to roll back values to the start of the transaction or to the preceding commit point.