how to get the month first & last dates by month name in sql

Question

Hi I have a web form in that I have two dropdown values where I can select year, basing on year I can select particular month. Now I am sending this month name as parameter to database, in db basing on month name I have get the first date and last date of month which was passed as parameter to sql server 2012 I have stuck at this point to retrieve them Any help Thanks in Advance

Ankit Sharma · Answer

Hi Phani, if you are passing only the month name, then how can u get the date?? i think you need to pass month and year both. use this SQL query DECLARE @ Month int DECLARE @ Year int set @ Month = 2 set @ Year = 2004 select DATEADD( month ,@ Month -1,DATEADD( year ,@ Year -1900,0)) as FirstDate select DATEADD( day ,-1,DATEADD( month ,@ Month ,DATEADD( year ,@ Year -1900,0))) as LastDate Let me know if this works for your case .

Phani Kumar · Answer

Thanks Ankit, using both the queries, I got the result what I wanted to see in my form

Ankit Sharma · Answer

Hi, Use this method to convert your month name to month number . then you can use the method i mentioned in previuos comment to get dates DECLARE @getmonth TINYINT, @datestring VARCHAR (20), @input VARCHAR (20), @ Year VARCHAR (20) SET @input = 'March' SET @ Year = 2015 SET @datestring = @input + @ Year SET @getmonth = MONTH ( CAST (@datestring AS DATETIME)) SELECT @getmonth

Phani Kumar · Answer

I am passing both month & year, here I am paasing the name of month not the month number, while converting I am getting an erro unable to convert

how to get the month first & last dates by month name in sql

Answers (4)