select currentdate,currenttime from sysibm.sysdummy the above date and tim

How can you display the current date & current time ?

Question Posted / raghu

Answer Posted / raghu

select currentdate,currenttime from sysibm.sysdummy
the above date and time are scalar functions and it from the timestamp

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How can deadlocks be resolved?

887

What is db2 look?

967

How to find the number of rows in a db2 table?

1062

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1027

Define check constraint.

1023

What is the use of value function?

1070

What is the role of the data page in the db2 database?

971

What is declare cursor?

1038

What is the clustering index in the db2 database?

955

How to access db2 tables in mainframe?

989

What is the use of commit in db2?

998

What is access path in db2?

923

How do you stop a db2 database in linux?

951

What is the physical storage length of the data types: date, time, timestamp in the db2 database?

1101

What is the syntax for creating a table in the db2 database?

1054