In Access 'Select date()' In Oracle 9i 'Select Sysdate from

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

Question Posted / selvaraj.v

Answer Posted / selvaraj.v

In Access 'Select date()'
In Oracle 9i 'Select Sysdate from dual;'
In SQL Server 2000 'Select Getdate()'

Is This Answer Correct ?

33 Yes

7 No

Please Help Members By Posting Answers For Below Questions

How can you control the amount of free space in your index pages?

1010

Explain iaas, paas and saas?

How can you insert values in multiple rows using one Insert statement?

1036

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

920

How to connect of datebase with sql express.?

1050

What is a primary key?

899

What is transaction server auto commit?

984

What are click through reports?

138

What is normalization 1nf 2nf 3nf?

1003

How to automatically create a log when an exception is being received into SQL Server?

1210

How many types of objects are there?

935

What will be the maximum number of index per table?

951

What is statement level trigger?

935

What is 2nf normalization?

967

How do I run a trace in sql server?

929