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 |
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What are db2 objects?
What do the initials DDL and DML stand for and what is their meaning?
What's the difference between DB2 active log and archive log? Thanks a lot...
What is cobol db2?
What is dbrm library?
What are the advantages of using a PACKAGE?
Can we able to find all the Table names under a Particular Plan?
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
What is access path in db2?
What is the STOSPACE Utility used for?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?