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

Before you give the explain statement, what are the prerogatives?

Can you search give an array in the WHERE clause of a db2 query?

What is the maximum size of varchar data type in db2?

how will you retrieve first record in table

What is difference between isnull and coalesce?

How many buffer pools are there in DB2?

WHAT IS NULL INDICATOR ? WERE IS THIS USED? AND IF IT IS USED IN FILES CONCEPT? HOW DO WE USE IT?

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

What is dbrm?

Could anyone clearly explain the diference between sub query and correlated sub query?

the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1

What is bufferpool in db2?

For more DB2 Interview Questions Click Here