Interested to Buy Any Domain ? << Click Here >> for more details...
How can you display the current date & current time ?
- 7 Answers
- 12918 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 |
database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please
why we go for SPUFI for creating tables or for sql queries?
Is db2 a mainframe?
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
When can an insert of a new primary key value threaten referential integrity?
How to find the number of rows in a db2 table?
How does DB2 use multiple table indexes?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
how to identify the pseudo conversation by seeing the program
What happens to the PLAN if index used by it is dropped?
When would you prefer to use VARCHAR?
COBOL 
