sql.How to get begin and end date of any quarter

PHOTO EMBED

Sat Oct 09 2021 17:18:15 GMT+0000 (UTC)

Saved by @rick_m #sql

DECLARE @Year DATE = '2013-01-01'
DECLARE @Quarter INT = 4;

SELECT  DATEADD(QUARTER, @Quarter - 1, @Year) ,
        DATEADD(DAY, -1, DATEADD(QUARTER,  @Quarter, @Year))
content_copyCOPY

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/7ac4bd64-0d12-4959-b535-6f28624132eb/how-to-get-begin-and-end-date-of-any-quarter-in-sql-server-2008