How can you display the current date & current time ?

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

Outputs of explain are with matchcols = 0. What does this signify?

709


What are the contents of dclgen?

745


What is dpf in db2?

753


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

679


i want to maintain uniqueness on pdf without make lf??????????

1739






Define db2 and its databases?

708


How does coalesce work?

670


What is with ur in db2?

884


How do we specify index to include or not during bind process.

1766


What is page size in db2?

638


What is meant by dclgen?

705


What is isolation level in db2?

655


What is nvl in db2?

727


Explain how can you do the explain of a dynamic sql statement?

751


What is the use of reorg in db2?

698