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

What is the difference between NOROW and LOCKROW?

2838

what is normalization? : Sql server database administration

1096

What purpose does the model database server?

1099

Can we write trigger for view?

1010

What do you understand by hotfixes and patches in sql server?

991

Is mysql better than sql server?

1060

Explain what you mean by 3 tier architecture.

1077

New concepts of sql server 2005 use in your project.

2361

What is data source in connection string?

908

What are rows and columns?

1019

Explain the difference between primary keys and foreign keys?

1024

What is clustered vs nonclustered index?

947

How to see existing views in ms sql server?

1044

What are subqueries in sql server?

1121

How can you list all the columns in a database?

930