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?..

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

How to find schema of a table in db2?

0 Answers  


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

3 Answers  


What types of tables are there in the db2 database?

0 Answers  


Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  


How to handle null values in db2

4 Answers  






What is a plan and package in db2?

0 Answers  


What is the picture clause of null indicator variable?

0 Answers  


what is a trigger and types of triggers

3 Answers   HSBC,


What is image copy in db2?

0 Answers  


What is the syntax for seeing the columns and data types of a table in the db2 database?

0 Answers  


What is a cursor?

2 Answers  


How to connect to db2 database from windows command line?

0 Answers  


Categories