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

When do you specify the isolation level?

621


what are bind concepts in db2 cobol?

662


What is the use of runstats in db2?

591


What action db2 takes when a program aborts in the middle of a transaction?

671


define clustering index.

629






by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?

7556


What is ibm db2 client?

530


What is null value in db2?

581


What is db2?

751


How to fetch the last row from the table in SQL (db2)?

1047


What is bind in db2?

612


What is the usage of open cursor command?

613


How can you count the number of rows from a table tab?

647


What is the physical storage length of date data type?

741


What is the physical storage length of the data types date, time, and timestamp?

629