select sysdate from dual;

How can you display the current date & current time ?

Question Posted / damy

7 Answers
12559 Views
Cap Gemini, I also Faced
E-Mail Answers

Answer Posted / damy

select sysdate from dual;

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Highlight all the advantages that are attached to a package.

1070

What is bind package and plan in db2?

1004

What is a trigger in the db2 database?

1013

Define declaration generator (dclgen).

1065

Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

1002

What is db2 plan table?

991

How and when does the db2 enforces the unique key?

1028

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2020

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2663

Mention data types used in db2 ?

1101

What is null value in db2?

944

How to get the ddl of a table in db2?

1071

What are union and union all?

920

What are db2 objects?

999

What is isolation level in db2?

938