Write a SQL Query to get the Quarter from date.

Rajeev Kumar

1.8k

TheDate	Quarter
01/10/2024	Q1

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

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;