Get month from the datatime column in SQL Server

DateName function in SQL Server:

         DateName function will be used to fetch the data/month/year/time from the datetime column.
drop table sample_table
create table sample_table (id int, dat datetime)
insert into sample_table values(1,getdate())
select * from sample_table
select id,dat from sample_table where datename(month,dat)='June'

-----------------------------------------
 id            dat
-----------------------------------------
 1        2010-06-07 10:54:52.607
-----------------------------------------
Cheers,
Venkatesan Prabu .J
http://venkattechnicalblog.blogspot.com/