WHERE Clause to find all records in a specific month

by

I think the function you’re looking for is MONTH(date). You’ll probably want to use ‘YEAR’ too.

Let’s assume you have a table named things that looks something like this:

id happend_at
-- ----------------
1  2009-01-01 12:08
2  2009-02-01 12:00
3  2009-01-12 09:40
4  2009-01-29 17:55

And let’s say you want to execute to find all the records that have a happened_at during the month 2009/01 (January 2009). The SQL query would be:

SELECT id FROM things 
   WHERE MONTH(happened_at) = 1 AND YEAR(happened_at) = 2009

Which would return:

id
---
1
3
4

More Related Contents:

  1. to select all the employees who have joined most recently under king
  2. Unpivot with column name
  3. How can I delete using INNER JOIN with SQL Server?
  4. Convert varchar into datetime in SQL Server
  5. sql query to return differences between two tables
  6. SQL Joins Vs SQL Subqueries (Performance)?
  7. Check if a row exists, otherwise insert
  8. How to do pagination in SQL Server 2008
  9. formula for computed column based on different table’s column
  10. SQL comments on create table on SQL Server 2008
  11. Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)
  12. How to write UPDATE SQL with Table alias in SQL Server 2008?
  13. SQL Server 2008- Get table constraints
  14. Restrict an SQL Server connection to a specific IP address
  15. How does this CASE expression reach the ELSE clause?
  16. is of a type that is invalid for use as a key column in an index
  17. Why are logical reads for windowed aggregate functions so high?
  18. How can I group time by hour or by 10 minutes?
  19. Grant SELECT permission on a view, but not on underlying objects
  20. Using IF ELSE statement based on Count to execute different Insert statements
  21. SQL Server SELECT INTO @variable?
  22. How do I change db schema to dbo
  23. How to subtract 30 days from the current date using SQL Server
  24. Count records for every month in a year
  25. How to export data from Excel spreadsheet to Sql Server 2008 table
  26. SQL Server: +(unary) operator on non-numeric Strings
  27. Use one CTE many times
  28. Bulk insert using stored procedure
  29. How to do a case sensitive GROUP BY?
  30. How to automatically generate unique id in SQL like UID12345678?

Leave a Comment