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 table valued function and scalar valued functions?

1059

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

1001

Which command is used for user defined error messages?

1052

Distinguish between nested subquery and correlated subquery?

1021

What information is maintained within the msdb database?

954

Can a table be created inside a trigger?

954

Where sql server user names and passwords are stored in sql server? : sql server database administration

1034

What is tablix?

160

What is the template in sql?

963

What do you mean by table and field in sql?

989

Define a cross join?

989

How do database indexes work?

994

Does dbcc checkdb requires db to be in single_user mode? : sql server database administration

957

What is the index requirement in SQL Azure?

Can an entity have two primary keys?

964