I was requested to make a store procedure that is able to retrieve results from a log table based on the today's month, which has to start from the 1st day of the month to the last day of the month. After a no-brainer's action: Google it! some results were found and quite useful. but most of the version found on the internet does not cover the "time". (it has to return the first day and time , as well as last day and time such as 01/01/2008 12:00AM - 01/31/2008 11:59:PM)

So I took my time to write a simple query to get the last date and first date of the month. Post comments below if you have any better ideas or comments

    DECLARE @FirstDate datetime
    DECLARE @LastDate datetime
    DECLARE @Today datetime

    SELECT @Today = getDate()
    SET @FirstDate = CAST(CONVERT(varchar(2),MONTH(@Today)) + '/01/' + CONVERT(varchar(4),YEAR(@Today)) as DATETIME)
    SET @LastDate = DateAdd(second, -1, DateAdd(M,1,@FirstDate))
 

    -- @FirstDate returns 'Mar  1 2008 12:00AM'

    -- @LastDate returns 'Mar 31 2008 11:59PM'