Write a SQL Query to get the Quarter from date.

Rajeev Kumar

TheDate	Quarter
01/10/2024	Q1

5 Answers

SELECT DATEPART(QUARTER, Columname) AS quarter FROM Tablename

SELECT DATEPART(QUARTER, your_date_column) AS Quarter
FROM your_table

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

SELECT TheDate, 'Q' CAST(DATEPART(QUARTER, TheDate) AS VARCHAR) AS Quarter FROM YourTableName;

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