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 are the differences between substr and charindex in sql server.

1113

What are the different acid properties?

1065

What is spid in sql server profiler?

1101

What is correlated subquery in sql server?

1070

Define msdb database?

1014

How will you hide an attribute? : sql server analysis services, ssas

957

What is the New in SQL server 2008?

973

What security features are available for stored procedure?

1036

What is standby servers? Explain types of standby servers.

995

Tell me what is log shipping?

977

What is side by side migration in sql server?

1100

Why can there be only one clustered index and not more than one?

1005

How to find the list of fixed hard drive and free space on server?

1196

Define union, union all, minus, intersect?

974

What is the security model used in sql server 2005?

1007