Findout First Day and Last Day With Time Of The Previous Month By Using SQLAkash Garg13yPublished Apr 9, 2013, 12:00 AMUpdated Apr 10, 2013, 2:08 AM3.7k00Reactions×25Blog The SQL query is shown belowSELECT DATEADD(month, DATEDIFF(month, -1, getdate()) - 2, 0) as FirstDayWithTime, DATEADD(ss, -1, DATEADD(month, DATEDIFF(month, 0, getdate()), 0)) as LastDayWithTime CommentsJoin the conversation! Your thoughts help the community grow.Sign in to leave a commentIt is the same account you read, post and publish with — and you will come straight back to this page.Sign inCreate an account
Join the conversation! Your thoughts help the community grow.