How can you display the current date & current time ?
- 7 Answers
- 11746 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
On which levels locks can be applied?
What is the use of value function?
What is copy pending status in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
Give a brief description of db2 isolation levels?
Are view updateable?
Where can you declare a cursor in a cobol-db2 program?
What is database alias db2?
Which is faster delete or truncate?
Mention the location where the output received from explain statement is stored.
What is the role of the data page in the db2 database?
Why do chiropractors use drop table?
what is utility for parm lib
What do you mean by rollback?
What is the maximum size of varchar data type in db2?
