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

What is the difference between insensitive and scroll cursor?

1160

How do I find information about the install locations for the various instances running on a computer?

1085

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

967

What is data block and how to define data block size?

1027

What is the template in sql?

978

What is dirty read?

1080

explain extended properties

991

What is b tree index?

915

How can a database be repaired?

988

How to find the login name linked to a given user name?

1011

How to create percentile function?

153

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

989

How do I edit a stored procedure in sql server?

926

How to insert and update data into a table with "insert" and "update" statements?

987

What are the dis_advantages of stored procedures, triggers, indexes?

2226