select date() does not work in Access 97.

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

Question Posted / smithers

Answer Posted / smithers

Is This Answer Correct ?

4 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Explain the xml support sql server extends?

1023

How do you migrate data from mssql server to azure?

165

How to retrieve error messages using mssql_get_last_message()?

1031

Can we use pragma autonomous_transaction in trigger?

941

mention different types of relationships in the dbms?

1002

How sql server executes a statement with nested subqueries?

1010

Explain nested join?

959

What is clustered vs nonclustered index?

932

What is the purpose of grouping data in a report?

942

How to insert data into an existing table?

961

What is awe?

991

What happens if we shrink log file in sql server?

962

What are the types of indexes?

1067

What are the restrictions applicable while creating views? : SQL Server Architecture

1008

Explain security with sql azure?

186