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

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

Ebook Download
View all
Learn
View all