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
How many databases are there?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What are packages in db2?
Can you use max on a char column?
What do you mean by storage group (stogroup)?
What is the syntax for FETCH in DB2 ?
What is the latest version of ibm db2?
How and when does the db2 enforces the unique key?
What is a plan and package in db2?
Is db2 relational database?
What is data manager?
What is db2 catalog database?
Is db2 free?
What is reorg?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?