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

Where are sql server user names and passwords stored in sql server?

1152

How do I run sql server 2014?

1052

Can you always create a cache of a report?

178

List out what other servers you can use with ssrs?

145

How to write a query with an inner join in ms sql server?

1092

How to see the event list of an existing trigger using sys.trigger_events?

1126

List the different types of joins?

1056

What are different types of raid configurations? : SQL Server Architecture

1128

Can we use pragma autonomous_transaction in trigger?

1012

How to write a query with a full outer join in ms sql server?

1154

What is difference between sql and sql server?

1079

How to declare and use cursor variables?

1248

What security features are available for stored procedure?

1073

What is row_number () and partition by in sql server?

1130

Explain “@@rowcount” and “@@error” in sql server?

1128