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 does db2 blu stand for?
What is the role of the data page in the db2 database?
What is the SQL Communications Area and what are some of its key fields?
What is an instance database?
How do I add a column in db2?
How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What is null in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How many buffer pools are available in db2?
what is the soft code for deadlock ?
What DB2 Catalog column tell you when an index needs table reorganized ?
What is UNION,UNION ALL?