Interested to Buy Any Domain ? << Click Here >> for more details...
How can you display the current date & current time ?
- 7 Answers
- 13136 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 |
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
How can you get the number of rows impacted by the last executed query?
What are the three DB2 date and time data types and their associated functions?
What is cursor stability in db2?
What is a root page?
Can we declare DB2 HOST variable in COBOL COPY book?
Can a primary key have null values? If we try to insert a null value in a primary key column, will it work or give an error code?
What is dclgen in db2?
What Utility is used to migrate DB2 from one release to the next?
How can we read records for specific member in CL? AND rpg?
Define db2 and its databases?
What is null indicator in cobol db2?
COBOL 
