How can you display the current date & current time ?
- 7 Answers
- 11072 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / prabu
select getdate()
In SQL Server, We can get current date and time
If this answer is not correct give me feedback
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / raghu
select currentdate,currenttime from sysibm.sysdummy
the above date and time are scalar functions and it from the timestamp
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / g.naveen
ASKTIME is command used to display the current Date & Time
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / umesh
you can ge the current date and time by using the command
date
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ganesh kumar
Answer
# 1
ASKTIME is command used to display the current Date & Time
| Is This Answer Correct ? | 0 Yes | 3 No |
What else is there in the PLAN apart from the access path?
How to resolve -805 error in DB2?
How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?
wht displays the number of times a query modified ?
What is an alias?
How can we read records for specific member in CL? AND rpg?
What is an alias and how does it differ from a synonym?
What is filter factor?
cobol-db2 runjcl please?
Is the primary key a clustered index?
How do I optimize a query in db2?
What does a deadlock mean in DB2?
COBOL 
