Interested to Buy Any Domain ? << Click Here >> for more details...
How can you display the current date & current time ?
- 7 Answers
- 12878 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 |
Why use RUNSTAT Utility?
Shall i use this query to retrieve first 4 records, Select empno, sal from emptbl where empno < 5. like this can we fetch first 100 records?
Is db2 a mainframe database?
what are stage one indexable predicates?
What is a collection?
What are leaf pages?
What information can you find in SYSIBM.SYSLINKS table?
What is db2 catalog database?
how to copy the host variables from ps file into cobol program other than include statement
how do you resolve -805?
What is a trigger in the db2 database?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
0 Answers ITC Infotech, Syntel,
COBOL 
