How can you display the current date & current time ?
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
Which isolation level provides highest data integrity?
How to restart a DB2 program?
What are union and union all?
What are the benefits of using the db2 database?
How can you classify the locks in db2?
List out the data types available.
What is a page in db2?
What is cursor in dbms?
What are the bind parameters ibm db2?
What is image copy in db2?
Which component is responsible for db2 startup and shutdown?
Are views updateable?
What is meant by union and union all?
What is a db2 table?
What is the information associated with sysibm.syslinks table?