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 resolve -805 . how to see dbrm and package not found

2 Answers   IBM,


What is copy pending and check pending in db2?

0 Answers  


What's The Error Code For Unique Index Voilation?

0 Answers   IBM,


What is catalog database in db2?

0 Answers  


What is a DB2 access path?

1 Answers  






What are the disadvantages of PAGE level lock?

3 Answers  


How can you do the explain of a dynamic sql statement?

0 Answers  


What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

0 Answers   MCN Solutions,


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

0 Answers   HeadStrong,


What is the difference between plan and package in db2?

0 Answers  


What is db2 isolation?

2 Answers  


What do the initials DDL and DML stand for and what is their meaning?

2 Answers  


Categories