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 many instances per computer are there in sql server 2000?

1078

Is it true, that there is no difference between a rule and a check constraint?

1058

How many partitions a clustered index has by default in sql server 2012?

1089

List the different index configurations possible for a table?

934

What is the difference between executequery () and executeupdate ()?

1041

How to create percentile function?

153

What is a fill factor?

1087

Which language rdl files made of?

130

Explain about sql server login?

1088

What is cdc in sql server?

1001

What is the query and subquery?

1078

What is outer join in sql server joins?

1120

Explain sub-query?

957

What is 2nf normalization?

1028

What are the properties of primary key?

974