What are the three DB2 date and time data types and their
associated functions?
- 1 Answers
- 5061 Views
- I also Faced
- E-Mail Answers
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 is reorg and runstats in db2?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
What is the information associated with sysibm.syslinks table?
Write a query to extract first 5 characters of a name in the column Stud_Name?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
What is the latest version of ibm db2?
Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.
What is the meaning concurrency in the db2 database?
What does a deadlock mean in DB2?
what is datacom db?
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
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
COBOL 
