SELECT DATEPART(QUARTER, Columname) AS quarter FROM Tablename

select YourDateColumn DATEPART(QUARTER, YourDateColumn) AS Quarter FROM YourTableName

SELECTTheDate,'Q' CAST(DATEPART(QUARTER, TheDate) AS VARCHAR) AS Quarter FROMYourTableName;

SELECT your_date_column, DATEPART(QUARTER, your_date_column) AS quarter FROM your_table_name;