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 a corelated subquerry?
What is cursor with hold option in db2?
Why do we need reorg in db2?
How many databases can be created inside an instance in db2 ?
List down the types of triggers in the db2 database?
What is blu acceleration in db2?
Explain what are the various isolation levels possible?
What is the cobol picture clause of the db2 data types date, time, timestamp?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
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
Where do you specify them?
What are bind parameters in db2?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is a bind in db2?
How to retrieve rows from a db2 table in embedded sql?