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


Please Help Members By Posting Answers For Below Questions

Which isolation level provides highest data integrity?

675


How to restart a DB2 program?

1456


What are union and union all?

626


What are the benefits of using the db2 database?

760


How can you classify the locks in db2?

721






List out the data types available.

798


What is a page in db2?

692


What is cursor in dbms?

701


What are the bind parameters ibm db2?

708


What is image copy in db2?

649


Which component is responsible for db2 startup and shutdown?

712


Are views updateable?

732


What is meant by union and union all?

670


What is a db2 table?

684


What is the information associated with sysibm.syslinks table?

755