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 do you understand by hotfixes and patches in sql server?

1028

What are the new data types are introduced in sql 2000?

944

What are examples of triggers?

1124

Which rendering formats are affected by the pagesize properties?

151

Where are sql server usernames and passwords stored in the sql server?

1168

how to create “alternate row colour”?

152

How do I find sql server instance name?

1002

Can the “if update (colname)” statement be used in a delete trigger?

1032

What are policy management terms?

1036

Tell me what is fill factor?

1007

Can you tell me about the concept of ER diagrams?

1121

What is the command used to check locks in microsoft sql server?

1093

What is a trigger what are the advantages of trigger?

1059

How do you send email on SQL Server?

1110

How you can get a list of all the table constraints in a database? : Sql server administration

1087