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

Explain the function of data manager.

0 Answers  


can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?

1 Answers  


What is REORG? When is it used?

4 Answers  


how we will do null data selection in cobol-db2 program

2 Answers   Wipro,


wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  






How to insert more than one record using insert?

7 Answers   Atos Origin, IBM,


What are the contents of dclgen?

0 Answers  


What are iseries servers?

0 Answers  


Q4. How will you get the count of record without using COUNT verb in query?

2 Answers   IBM,


What is a LIKE table and how is it created?

2 Answers  


where will u check for sqlcode ?

2 Answers   TCS,


What is IMAGECOPY ?

6 Answers  


Categories