T-SQL Query For Beginning And End of Any Month

I’ve used this technique many times to help grab the beginning and end of a month. It’s useful for queries where you need to use a BETWEEN.

Sample usage:

I hope this is helpful to you in your querying adventures. Got another way to accomplish the task? I’d love to hear from you. Post a comment below.


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.