i donot abt the SQLserver2000and MSaccess.But in ORACLE we get current da

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

Question Posted / nikita

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

Please Help Members By Posting Answers For Below Questions

Give an example of SQL injection attack ?

928

What is a table called, if it has neither cluster nor non-cluster index? What is it used for?

977

Do you know the policy based administration feature of sql server 2008?

905

How do you delete a data source?

953

What is a coalesce function?

1130

Explain data warehousing in sql server?

988

What is meant by indexing?

939

What is a non equi join?

913

What is a trigger what are the advantages of trigger?

914

What is recompile sql server?

989

what are user defined datatypes and when you should go for them? : Sql server database administration

961

What are the differences between user defined functions and stored procedures?

1004

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

933

What is the significance of null value and why should we avoid permitting null values?

915

Where do we use trace frag?

968