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 |
What is the error code -803 ?
What is JOIN and different types of JOIN.
What is cursor with hold option in db2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
What is the use of value function?
What is the physical storage length of the data types date, time, and timestamp?
How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
If I have a view which is a join of two or more tables, can this view be updateable?
What is role in db2?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
how can we find nth max salary from A table