How do we get current date in SQL Server 2000, Oracle, MS
Access?

Answer Posted / nikita

i donot abt the SQLserver2000and MSaccess.But in ORACLE we
get current date by following SQLstmt:
SELECT sysdate() FROM DUAL;

Is This Answer Correct ?    32 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain having clause?

727


What is outer join in sql server joins?

748


What is meant by Active-Passive and Active-Active clustering setup?

749


What is a trigger? Why we need it?

690


Why we should not use triggers?

685






How to delete multiple rows with one delete statement in ms sql server?

693


What are the hotfixes and patches in sql server?

747


Can we use where and having clause together?

711


Explain transaction server distributed transaction?

675


What is the distinction amongst delete and truncate?

737


How many types of triggers in sql server?

711


What are the five characteristics of good data?

680


Why are you getting errors when creating a new odbc dsn?

803


What is attribute hierarchy? : sql server analysis services, ssas

713


what are the three command line utilities and what are their primary functions?

119