Last date of the month. sql date process

home
database
view story

3 Kicks

Last date of the month. sql date process(weblogs.asp.net)

submitted by wisemx(8074) 4 years, 2 months ago

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)

add a comment |category: Database |Views: 2
Tweet