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
When do you specify the isolation level?
what are bind concepts in db2 cobol?
What is the use of runstats in db2?
What action db2 takes when a program aborts in the middle of a transaction?
define clustering index.
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?
What is ibm db2 client?
What is null value in db2?
What is db2?
How to fetch the last row from the table in SQL (db2)?
What is bind in db2?
What is the usage of open cursor command?
How can you count the number of rows from a table tab?
What is the physical storage length of date data type?
What is the physical storage length of the data types date, time, and timestamp?