How can you display the current date & current time ?
- 7 Answers
- 11645 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
What is bind plan?
Mention the location where the output received from explain statement is stored.
What happens in bind step in a db2 program?
What is cascading rollback?
Can one database have multiple instances?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What is commit in db2?
Define db2.
How do I create a view in db2?
How do I optimize a query in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
How to check table size in db2 sap?
What is the difference between drop table and delete table?
What is the difference between spufi and qmf?
Explain the contention situations caused by locks?
