hai ,

I need to get the monthnames between 2 dates such as 01-04-2012 & 30-03-2013 .
Can you help me to get it.

Thanks in advance,
sreevidya

what have you done so far?

select datename(month,datecol) from tbl where dt between ..........

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.