SELECT GETDATE() AS 'Current Date' GO

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

Question Posted / lrk

Answer Posted / lrk

SELECT GETDATE() AS 'Current Date'
GO

Is This Answer Correct ?

66 Yes

20 No

Please Help Members By Posting Answers For Below Questions

How to resolve the orphan use problem? : sql server security

956

Difference between report and query parameter. Why do we need different type of parameter?

906

What do you mean by stored techniques? How would we use it?

980

How to skip remaining statements in a loop block using continue statements?

935

What is clustered primary key?

960

What happens if you are trying to access a schema not owned by you?

914

What do you understand by mirroring and mention the advantages of the mirroring?

1008

What are cascading parameters in ssrs reports?

212

Explain different types of self contained sub query?

951

What is lock escalation? : sql server database administration

1103

What is the maximum rows in sql server table?

868

Is null vs coalesce?

817

What command would you use to add a column to a table in sql server?

1236

What is cross join in sql server joins?

1076

What is log cache in sql server?

984