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
Which are the db2 tools to protect integrity of the database?
What are iseries servers?
What does a deadlock mean in DB2?
What is host variable?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the difference between cursor stability and repeatable read isolation levels?
What is precompiler in db2?
What is a db2 package?
Is schema the same as database?
Which component is responsible for processing sql statements and selecting access paths?
What is node in db2?
can we view the access paths created by dbrm ? how ? thx
Where can you declare a cursor in a cobol-db2 program?
What is the use of with ur in db2?
What is nvl in db2?