How can you display the current date & current time ?



How can you display the current date & current time ?..

Answer / mr. cooooool

SELECT CURRENT DATE, CURRENT TIME FROM SYSIBM.SYSDUMMY1;

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More DB2 Interview Questions

What is an asychronous write?

1 Answers  


cobol-db2 runjcl please?

2 Answers   DELL,


If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  


What are catalog tables in db2?

0 Answers  


Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq

2 Answers  






In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?

6 Answers   TCS,


What type of database is db2?

0 Answers  


How can you compare table column after update and before update?

5 Answers   Satyam,


What is the cascade rule and how does it relate to deletions made with a subselect?

1 Answers  


What is a correlated sub query?

2 Answers  


What is a clustered index?

1 Answers  


How do you pull up a query which was previously saved in qmf?

0 Answers  


Categories