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'