What are the three DB2 date and time data types and their
associated functions?
Answer Posted / 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 View All Answers
What is dclgen in db2?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is dbrm library?
How can deadlocks be resolved?
What is the advantage in De-normalizing tables in DB2?
What is check constraint. Explain with example.
What is explain in db2?
Is the primary key a clustered index?
Mention some fields that are a part of sqlca.
What are the contents of dclgen?
Is db2 a mainframe database?
What are union and union all?
What is commit in db2?
On which levels locks can be applied?
What is cascading rollback?