How can you display the current date & current time ?
- 7 Answers
- 13310 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 |
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is the difference between db2 and oracle?
What is COPY PENDING status?
When Can you be sure that a query will return only one row?
How can you classify the locks in db2?
Explain various types of locks in db2?
What is the difference between TYPE 1 index & TYPE 2 index
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
What can the SET option of the Repair Utility accomplish?
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What are delete-connected tables?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
COBOL 
