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 normalization? : Sql server database administration

1083

What is mean by candidate key?

1001

what are the important architecture components of SSRS?

140

What is the use of floor function in sql server?

1071

What is join and name different type of joins?

1040

What happens when converting big values to numeric data types?

1114

How to deploy the Report?

138

What is sql server used for?

1035

What is a not null constraint?

1016

When would you use the stored procedures or functions?

998

Explain transaction server consistency?

961

What is the size of transaction log file?

919

what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1040

What are the requirements to use odbc connections in php scripts?

1104

How to delete duplicate records based on single column from a table?

1038