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

Phani Kumar

9y2.2k.NET

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

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ankit Sharma9y ago
Accepted 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 Kumar9y ago
Thanks Ankit,

using both the queries, I got the result what I wanted to see in my form
Ankit Sharma9y ago
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 Kumar9y ago
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