Query to find Last day of the current month

Posted by Kirthiga under Sql Server on 5/23/2018 | Points: 10 | Views : 658 | Status : [Member] | Replies : 13
How to find last day of the current month in sql server




Responses

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

Up
0
Down
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

Posted by: Saraabo1 on: 6/7/2018 [Member] Starter | Points: 25

Up
0
Down
https://www.quickensupportnumber.com Quicken Support Number


Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saraabo1 on: 6/7/2018 [Member] Starter | Points: 25

Up
0
Down
http://www.hpsupportnumber.com/

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saraabo1 on: 6/7/2018 [Member] Starter | Points: 25

Up
0
Down
http://www.microsoftcustomersupports.com

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saraabo1 on: 6/7/2018 [Member] Starter | Points: 25

Up
0
Down
http://www.printertechservice.com

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saraabo1 on: 6/7/2018 [Member] Starter | Points: 25

Up
0
Down
http://www.antivirustechhelp.com/mcafee-antivirus.html

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saraabo1 on: 6/7/2018 [Member] Starter | Points: 25

Up
0
Down
http://www.mcafeehelpnumber.com

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saraabo1 on: 6/7/2018 [Member] Starter | Points: 25

Up
0
Down
http://www.mcafeehelpnumber.com

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saraabo1 on: 6/7/2018 [Member] Starter | Points: 25

Up
0
Down
http://www.antivirustechhelp.com/mcafee-antivirus.html

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saraabo1 on: 9/14/2018 [Member] Starter | Points: 25

Up
0
Down
http://toparticlesubmissionsites.com/how-to-tackle-mcafee-common-issues-with-mcafee-antivirus-phone-number/
https://www.kiwibox.com/mcafeehelpnumbe/blog/entry/145676141/fix-mcafee-scanning-issues-with-mcafee-customer-service-n/
http://ishowcase.net/mcafeehelpnumber/blog/19929/
http://www.writeupcafe.com/blog/8-other/175214-fix-login-issue-with-mcafee-customer-service-number
https://mcafeecustomersupportnumber.site123.me/blog/protect-the-mac-device-with-usa-mcafee-customer-support-number-1-800-329-1074
http://www.gorelations.com/blogs/4263/34337/how-to-fix-mc-afee-installation-problems-with-mc-afee-support-nu
http://mcafeehelpnumber.experts-academy.com/post/4920/update-mcafee-antivirus-with-mcafee-support-number-1-855-505-7815.html
McAfee Antivirus Phone Number
McAfee Help Number
McAfee Support Phone Helpline Number
McAfee Customer Service Number
McAfee Technical Support Number
McAfee Support Number
McAfee Customer Service

https://aol800number.wordpress.com/2018/07/21/fix-problems-sending-aol-mail/

https://www.bloglovin.com/@aolsupportnumber/facing-aol-gold-desktop-issues-get-solution

http://aolcustomerservices.blogmaster.net/post-facing-aol-gold-desktop-issues-get-the-solution-here-532804.html

https://www.customer-service-numbers.com/aol-mail-not-currently-available/

http://aolcustomerservice.populr.me/fix-aol-mail-gah-error-with-effective-methods

http://www.articles.kraftloft.com/Articles-of-2018/aol-desktop-not-responding

https://justpaste.it/aol-desktop-support

https://cyteis.com/aolhelptnumber/index

https://articlesforwebsite.com/access-aol-mail-on-windows-10-with-aol-support-number-1-800-279-1380/

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Saraabo1 on: 9/14/2018 [Member] Starter | Points: 25
Posted by: Unigroup on: 9/16/2018 [Member] Starter | Points: 25

Up
0
Down
https://unigroup.kiev.ua/kredit-pod-zalog-nedvizhimosti

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Wilda123 on: 9/19/2018 [Member] Starter | Points: 25

Up
0
Down
https://tollfree-help.co.uk

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response