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 the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration

825

What is the partitioning method?

746

What is stretch database in sql server?

761

Can you explain what is sql server english query?

726

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

695

What information is maintained within the msdb database?

721

What are joins in sql and what are the different types of joins?

712

How to create a trigger for insert only?

761

Explain cross join or cartesian product in sql?

698

What are the advantages of policy management?

749

What is command parameter in ssrs?

141

How to insert data into an existing table?

716

What is after dml trigger?

761

What are the extra roles available in msdb? : sql server security

845

What is the sql server agent?

782