Venkatesan Prabu (6/6/2010)
drop table sample_tablecreate 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
Ummm... I don't get it. How does that deal with the original request of converting month numbers to month names?
--Jeff Moden
Change is inevitable... Change for the better is not.