How can you display the current date & current time ?
Answer Posted / mr. cooooool
SELECT CURRENT DATE, CURRENT TIME FROM SYSIBM.SYSDUMMY1;
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is buffer pool and list some of them?
How to execute stored procedure in db2 command editor?
Which component is responsible for processing sql statements and selecting access paths?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is bind and rebind in db2?
What is role in db2?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
What is dbrm? When it will be created?
Which command is used to connect to a database in DB2 ? Give the Syntax.
Mention the definition of cobol in varchar field.
What is the syntax for creating a table in the db2 database?
How do I add a column to a table in db2?
What are the prerogatives?
Is db2 relational database?
What is a db2 cursor?