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

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

Question Posted / guest

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

Data types are DATE,TIME,TIMESTAMP

A few of the functions are
DATE
HOUR
MONTH
SECOND
TIME
TIMESTAMP

Is This Answer Correct ?

1 Yes

0 No

More DB2 Interview Questions

What is difference between rollback and commit?

What are the three lock types?

Define db2 and its databases?

db2 restart logic ?

What is the logical entity between plan and Package?

how to resolve -811 sqlcode .give clear explaination

What is a DB2 plan?

How to select the duplicate rows from a table?

How can you quickly find out the # of rows updated after an update statement?

Which components manage deadlocks in db2?

What is the function of buffer manager?

db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.

For more DB2 Interview Questions Click Here