How can you display the current date & current time ?
Answer Posted / 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 |
Post New Answer View All Answers
What is meant by explain?
How would the varchar column remarks defined?
What is alias in db2?
How do you select a row using indexes in db2?
How do you eliminate duplicate values in db2?
How to test SQL -911 error while developing COB-DB2 program
Which command is used to connect to a database in DB2 ? Give the Syntax.
Define buffer pool.
What is meant by dclgen?
What is sqlca’s maximum length?
What is database manager in db2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How do I delete a table in database?
What is the use of with ur in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?