SELECT CONVERT(varchar,GETDATE(),0) Return Value = Jun 6 2007

How do we get month name in SQL Server 2000, Oracle, MS Access?

Question Posted / anil sharma

Answer Posted / anil sharma

SELECT CONVERT(varchar,GETDATE(),0)
Return Value = Jun 6 2007

Is This Answer Correct ?

5 Yes

10 No

Please Help Members By Posting Answers For Below Questions

Define cursor locking

946

What are dml triggers and types of dml triggers?

921

What do you mean by an execution plan?

1051

What is a dbms wizard?

968

How to drop existing views from a database in ms sql server?

1039

What are the hotfixes and patches in sql server?

973

What is Command line parameters in PLSQL.?

1058

What is sql server english query?

1037

Is the primary key column of a table an index in ms sql server?

918

What is resultset concur_updatable?

969

what's the difference between a primary key and a unique key? : Sql server database administration

892

How do I start sql server?

924

How you would rewrite the sql query to return the customerid sorted numerically?

936

What are the grouping functions?

889

How to receive output values from stored procedures?

1054