Interested to Buy Any Domain ? << Click Here >> for more details...
How can you display the current date & current time ?
- 7 Answers
- 12883 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
How to get the ddl of a table in db2?
What db2 400?
Which components manage deadlocks in db2?
What is the picture clause of null indicator variable?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Which component is responsible for db2 startup and shutdown?
How do you concatenate the firstname and lastname from emp table to give a complete name?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
How do I import a csv file into db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
Mention the downsides of page level lock.
What is the default page size of buffer pools?
What is the clustering index in the db2 database?
What's The Percentage Free Space ?
