get quarter of current date in sql server 2008 [closed]

by

You can use datepart if you have quarters specified as 1,2,3 and 4 as:

declare @date date = getdate()

select case when  datepart(MM, @date) IN (4,5,6) then 'Q1' 
            when  datepart(MM, @date) IN (7,8,9) then 'Q2'
            when  datepart(MM, @date) IN (10,11,12) then 'Q3' 
            when  datepart(MM, @date) IN (1,2,3) then 'Q4' 
       end as Quater

More Related Contents:

  1. Need to find list of tables used in stored procedure with “nolock”? [duplicate]
  2. Find and Replace Column value from Over all Database
  3. Creating stored procedure getting Incorrect syntax near the keyword ‘Declare’
  4. Should I use != or for not equal in T-SQL?
  5. Conversion failed when converting date and/or time from character string while inserting datetime
  6. Foreign Key to non-primary key
  7. How should I pass a table name into a stored proc?
  8. Difference between left join and right join in SQL Server [duplicate]
  9. Dynamic SQL – EXEC(@SQL) versus EXEC SP_EXECUTESQL(@SQL)
  10. Get the last inserted row ID (with SQL statement) [duplicate]
  11. Fastest way to remove non-numeric characters from a VARCHAR in SQL Server
  12. Get all dates between two dates in SQL Server
  13. Get the week start date and week end date from week number
  14. Run all SQL files in a directory
  15. Rename column SQL Server 2008
  16. SELECT FOR UPDATE with SQL Server
  17. How to group by month from Date field using sql
  18. unresolved reference to object [INFORMATION_SCHEMA].[TABLES]
  19. How to get the numeric part from a string using T-SQL?
  20. SQL Server Update Trigger, Get Only modified fields
  21. SQL Server SELECT LAST N Rows
  22. update columns values with column of another table based on condition [duplicate]
  23. Why does using an Underscore character in a LIKE filter give me all the results?
  24. The transaction log for the database is full
  25. T-SQL: checking for email format
  26. SQL Server – Query Short-Circuiting?
  27. WITH CHECK ADD CONSTRAINT followed by CHECK CONSTRAINT vs. ADD CONSTRAINT
  28. Add a row number to result set of a SQL query
  29. Use one CTE many times
  30. How to Select Every Row Where Column Value is NOT Distinct

Leave a Comment