select month(getdate()) select month(dateparametername) from tablename -

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

Question Posted / foram

11 Answers
54686 Views
I also Faced
E-Mail Answers

Answer Posted / foram

select month(getdate())
select month(dateparametername) from tablename
---here u will get number of month
or

select datename(month,getdate())
select datename(month,dateparametername) from tablename
to get name of month

Is This Answer Correct ?

7 Yes

5 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are views used for?

1059

Why normalization is used?

1069

What is the federation in sql azure?

What is fill factor and pad index?

1061

What are the new features in SQL Server 2005 when compared to SQL Server 2000?

1214

Describe in brief sql server monitoring ways.

1102

List the types of recovery model available in sql server?

971

What are parameterized reports?

204

What samples and sample databases are provided by microsoft?

1089

Explain view in sql server?

1091

How to apply filtering criteria at group level with the having clause in ms sql server?

1046

How can change procedure in sql server?

1130

What is the New in SQL server 2008?

1017

How to execute multiple stored procedures at one time in sql server?

1064

What are different types of replication in sql server?

1146