Interested to Buy Any Domain ? << Click Here >> for more details...
What are the three DB2 date and time data types and their
associated functions?
- 1 Answers
- 5379 Views
- I also Faced
- E-Mail Answers
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
How is the value function used?
How can you classify the locks in db2?
How can you do the explain of a dynamic sql statement?
Differentiate between cs and rr isolation levels? Where do you specify them?
Mention data types used in db2 ?
Are view updateable?
What is the physical storage length of the data types date, time, and timestamp?
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
When do you specify the isolation level?
Explain packages.
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What type of database is db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Can one database have multiple instances?
What is the use of reorg in db2?
