How can you display the current date & current time ?
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 type of database is db2?
What is CHECK PENDING ?
What are host variables in db2?
What is the use of commit in db2?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
What is the purpose of the QUIESE Utility?
What are the various locks available?
How do you stop a db2 database in linux?
What is subquery ?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What will the COMMIT accomplish?
What is ALTER ?