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

How many types of page locks can be held in db2?

994

How do you simulate the explain of an embedded sql statement in spufi/qmf?

1025

can we view the access paths created by dbrm ? how ? thx

6974

What is a buffer in memory?

1006

Which component is used to execute the sql statements?

1053

What is bind package and plan in db2?

1005

What is db2 command?

963

What are the various isolation levels possible?

1048

What is coalesce in db2?

1055

What is catalog database in db2?

1100

What is the meaning concurrency in the db2 database?

1056

List out the data types available.

1081

What is an instance in db2?

983

What is the default page size of buffer pools?

1070

Which command is used to connect to a database in DB2 ? Give the Syntax.

1030