How to get calendar Quarter from a date in TSQL April 10, 2023 by Tarik SELECT DATEPART(QUARTER, @date) This returns the quarter of the @date, assuming @date is a DATETIME.