How can you display the current date & current time ?
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 |
What is a DB2 plan?
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
How can you get the number of rows impacted by the last executed query?
what is diffrence b/w file-aid tool and file-aid utility???
What is a NULL value? What are the pros and cons of using NULLS?
How can the duplicate values be eliminated from db2 select?
Which command is used to connect to a database in DB2 ? Give the Syntax.
what are the copybook changes generally we done?can anyone tell me......... Thanks in advance........
what is main use of table space and index object? please its urgent
5 Answers CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,
Which catalog table stores referential constraints?
Which transaction use a command thread ?
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