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

How to retrieve error messages using odbc_errormsg()?

1043

What is set nocount on?

932

How to select true false based on column value in sql server?

1010

Which joins are sql server default?

997

Why truncate is ddl?

1078

Explain the microsoft sql server delete command?

1011

What is a view and what are its advantages?

1104

When would you use it?

982

How to use group functions in the select clause in ms sql server?

1046

Why do we use trigger?

957

How to sort query output in descending order in ms sql server?

939

What is a raid and what are different types of raid configurations?

1259

Explain what is log shipping?

1129

Write an SQL query to obtain the 2nd highest salary.

1064

How can sql injection be stopped? : sql server security

1024