Home / Questions / 8154
Accepted
Ivxn
Asked: 2020-04-21 10:18:03 +0800 CST 2020-04-21 10:18:03 +0800 CST

Query to search by month and year

  • 772

I use VB.NET and SQL, how can I make a SQL query to obtain the records by year and month only? since normal queries are usually made by year, month and day, in this case I want to search for the records of '2016-10'

mysql

3 Answers

  1. Best Answer

    You would have to compare the month and year with the column that holds the date, something like this:

    SELECT * FROM tabla WHERE MONTH(colfecha) = 10 AND YEAR(colfecha) = 2016

    Thus, with the MONTH function you get the month and with the YEAR function you get the year inside the date. So you would only have to compare with the values ​​you want (10 and 2016 respectively).

    • 12

  2. In sentences sqlas far as the conditional wheregoes with = in that case your sentence would be like this:

    SELECT * FROM COMISION where month='10' and year='2016'

    otherwise you could use date range with BETWEENit like this:

    SELECT * FROM COMISION where (tu_campo_fecha) BETWEEN '2016-10-01' AND '2016-10-31'
    • 7

  3. In itself it is easy, if you have a date type field you can work with it like this:

    1. You have a date type field let's say a DATE() type field.

    2. CURDATE(), which returns the date of the current day according to the system.

    3. We combine them in the QUERY (query) and that's it.

    Step to the Example: Suppose a table called employees, a field of type DATE() called miCumple, now, what they ask us to do is to calculate the birthdays of the month so we do the query:

    select * from empleados where MONTH(miCumple) = MONTH(CURDATE());

    That would be all, you can pass it to a Stored Procedure or launch it simply like this, since from now on it will be enough to call that function and at any time you want you will have the birthday boys of the month, I hope it helps you...

    • 3