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

What is @@error in sql?

1051

Explain what are the basic functions for master, msdb, model, tempdb databases?

965

What is importing utility?

978

What happens to a trigger with multiple affected rows?

933

What is transaction server auto commit?

1056

How do I setup a local sql server database?

995

How to get @@error and @@rowcount at the same time?

1025

How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1982

How to check if a table is being used in sql server?

959

What is blocking?

1051

what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

1023

What is bcp? When does it use?

936

Can you tell me about the concept of ER diagrams?

1059

What is subreport?

141

Explain what are the restrictions while creating batches in sql server?

1058