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

1 Answers
5300 Views
I also Faced
E-Mail Answers

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

Answer / s

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

Post New Answer

More DB2 Interview Questions

Is the primary key a clustered index?

0 Answers

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.

6 Answers IBM,

When reorg is used?

0 Answers

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2 how will we do this. We can create a single program and a single load for this program.

2 Answers RBS,

how to resolve -805. give clear explination for that

2 Answers IBM,

What is the use of runstats in db2?

0 Answers

DB2 is a A) data base/data communication system B) data base C) RDBMS D) Programming language

4 Answers Accenture,

Is it possible to precompile if db2 goes down?

4 Answers Target,

What are the functions in DB2?

3 Answers Satyam,

What is the role of union all and union