SELECT CURRENT DATE, CURRENT TIME FROM SYSIBM.SYSDUMMY1;

How can you display the current date & current time ?

Question Posted / mr. cooooool

1 Answers
5087 Views
Cap Gemini, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is buffer pool and list some of them?

1028

How to execute stored procedure in db2 command editor?

1049

Which component is responsible for processing sql statements and selecting access paths?

1129

In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?

1105

What is bind and rebind in db2?

1139

What is role in db2?

1109

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?

9216

What is dbrm? When it will be created?

1029

Which command is used to connect to a database in DB2 ? Give the Syntax.

1104

Mention the definition of cobol in varchar field.

1250

What is the syntax for creating a table in the db2 database?

1109

How do I add a column to a table in db2?

1104

What are the prerogatives?

1080

Is db2 relational database?

980

What is a db2 cursor?

1056