How can you display the current date & current time ?

Question Posted / g.naveen

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

SELECT CURRENT DATE, CURRENT TIME FROM SYSIBM.SYSDUMMY1;

Is This Answer Correct ?

5 Yes

0 No

More DB2 Interview Questions

What is difference between *omit and *nopass?

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

In a single table,How to retrieve a employee-id of an employee who works in more than one department?

Differentiate between cs and rr isolation levels? Where do you specify them?

What is the physical storage length of the data types date, time, and timestamp?

What are the levels of isolation available with DB2V4

What does runstats do in db2?

While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

How will you return the number of records in table?

what is the use of commit ? and what is the syntax?

What is the use of commit in db2?

What is a bind in db2?

For more DB2 Interview Questions Click Here