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

Explain the contents that are a part of dclgen.

what is a plan and how do you refer the plan in the program?

In a DB2-CICS program which is acts as co-ordinator and which is participant?

What is the use of commit in db2?

What is data manager?

What is the difference between nvl and coalesce?

How do I delete a table in database?

what is parm utility

Is it possible to create an Instance in DB2 using DB2 Control Center ?

What is dbrm library?

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

What is package in db2 mainframe?

For more DB2 Interview Questions Click Here