Blog

Findout First Day and Last Day With Time Of The Previous Month By Using SQL

By Akash Garg Blogs | SQL Apr 09, 2013
We can find out the first and last day with time of the previous month by simple step.

The SQL query is shown below

SELECT DATEADD(month, DATEDIFF(month, -1, getdate()) - 2, 0) as FirstDayWithTime,

    DATEADD(ss, -1, DATEADD(month, DATEDIFF(month, 0, getdate()), 0)) as LastDayWithTime

COMMENT USING