SELECT CURRENT DATE, CURRENT TIME FROM SYSIBM.SYSDUMMY1;

How can you display the current date & current time ?

Question Posted / mr. cooooool

Answer Posted / mr. cooooool

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

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

1183

Why do we need reorg in db2?

1047

What is difference between alias and synonym in db2?

1197

Is ibm db2 open source?

1132

What are db2 tables?

1164

What is the advantage in De-normalizing tables in DB2?

1234

What is with ur in db2?

1384

Mention the definition of cobol in varchar field.

1315

What is the maximum size of a char data type in db2?

1052

What is universal database?

1118

Is the primary key a clustered index?

1204

What is db2 connect?

1124

Mention the downsides of page level lock.

1217

What is innodb buffer pool?

1135

What is dbrm? When it will be created?

1089