SQL date picker

Question

I want to be able to select all rows in the database where the month and year match what I'm looking for. Since the DATE field has a year, a month, and a day, how do I search for a year and a month?

Answer 1

SELECT *
FROM myTable
WHERE ( YEAR(myfield) = '2009')
  AND ( MONTH(myfield) = '1')

Answer 2

SELECT * 
FROM tblTableName 
WHERE Month(ColumnDate) = Month(MyDate) 
    AND Year(ColumnDate) = Year(MyDate)

Answer 3

, , , .

:

select SomeField
from SomeTable
where SomeDate >= ? and SomeDate < ?

( , , seond .)

: ( #)

DateTime start = new DateTime(date.Year, date.Month, 1)
DateTIme end = start.AddMonths(1);

Answer 4

MySQL:

SELECT *
FROM   mytable
WHERE  date >= STR_TO_DATE(CONCAT(EXTRACT(YEAR_MONTH FROM @mydate), '01'), '%Y%m%d')
   AND date < STR_TO_DATE(CONCAT(EXTRACT(YEAR_MONTH FROM @mydate), '01'), '%Y%m%d') + INTERVAL 1 MONTH

date.

Answer 5

, . IN SQl Server

where year(datefield) = @year and month (datefield) - @month 

.

or you can create a where clause by creating a date range

where the date field is between 20090101 and 20090201

Answer 6

You want to use MONTH () and YEAR () in mysql.