Query to find Last day of the current month

Posted by Kirthiga under Sql Server on 5/23/2018 | Points: 10 | Views : 3036 | Status : [Member] | Replies : 1

How to find last day of the current month in sql server

Reply | Reply with Attachment

Posted by: Rajnilari2015 on: 5/23/2018 [Member] [Microsoft_MVP] [MVP] Platinum | Points: 25

0	Try this select EOMONTH(getdate()), -- sql server 2012 onwards DATEADD(d, -1, DATEADD(m, DATEDIFF(m, 0, getdate()) + 1, 0)) -- any version of sql Hope this helps -- Thanks & Regards, RNA Team Kirthiga, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts