How to get first day of the previous quarter

Example:
--First day of the previous quarter
SELECT DATEADD(qq, DATEDIFF(qq, 0, GETDATE()) - 1, 0)
Result:

Post a Comment

0 Comments