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 the database descriptor?

How does DB2 store NULL physically?

Plan has the optimized access path in it. But is that optimized access path is attained or known

How to retrieve rows from a db2 table in embedded sql?

What is lock escalation?

What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

Explain the EXPLAIN statement?

What is the error code -803 ?

What is a data page?

What is the syntax required for the creation of a cursor?

Explain correlated sub-queries.

How to select the duplicate rows from a table?

For more DB2 Interview Questions Click Here