SELECT CURRENT DATE, CURRENT TIME FROM SYSIBM.SYSDUMMY1;

How can you display the current date & current time ?

Question Posted / mr. cooooool

1 Answers
5071 Views
Cap Gemini, I also Faced
E-Mail Answers

Answer Posted / mr. cooooool

SELECT CURRENT DATE, CURRENT TIME FROM SYSIBM.SYSDUMMY1;

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is check constraint in db2?

1075

How do I optimize a query in db2?

1095

What is drop table?

1002

what is the sqlcode -501

13127

Which command is used to remove all rows from a table?

1105

What is table space in db2?

1014

Which isolation level provides highest data integrity?

1114

What is deadlock in db2?

1062

Name the various locking levels available?

1089

List down the data types in the db2 database.

1112

What is rct?

1227

What is the difference between oracle and db2?

1096

What is explain in db2?

1010

by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

9185

What is alias in db2?

1051