Exec sql set :ws-current-date to current date End exec display 'c

How can you display the current date & current time ?

Question Posted / chandrika

7 Answers
12556 Views
Cap Gemini, I also Faced
E-Mail Answers

Answer Posted / chandrika

Exec sql
set :ws-current-date to current date
End exec

display 'current date' ws-current-date.

Exec sql
set :ws-current-time to current time
End exec

display 'current time' ws-current-time.

Is This Answer Correct ?

7 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to find primary key of a table in db2?

1001

What is the default page size of buffer pools?

1067

What is cascading rollback?

1129

List out the three types of page locks that can be held.

1090

How do I import data from excel to db2?

999

What is consistency token in db2?

1060

Define db2.

1061

What is reorg?

1064

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

1062

Explain about mirror activator disk mirroring?

952

How to access db2 tables in mainframe?

990

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2007

What is the role of schema in the db2 database?

1177

What is cursor with hold option in db2?

1008

What is the result of open cursor statement?

1027