Interested to Buy Any Domain ? << Click Here >> for more details...
How can you display the current date & current time ?
- 7 Answers
- 12893 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 stop a db2 database in linux?
What is meant by repeatable read?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
How would one remove old reorg information from the DB2 catalog?
What are the advantages of using a PACKAGE?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What are iseries servers?
What is package versioning? Please give an example.
wht r the requirements for writing a cobol-db2 pgm ?
what is the input to PLAN? what is the input to DBRM?
What are the functions of Bind?
can all users have the privilage to use the sql statement select * (dml)?
COBOL 
