Select with YEAR and MONTH together

Question

Select with YEAR and MONTH together

Navigation

#1 by (3 votes)

4

Is it possible to combine the year and the month together, and to pass the 20017-06 to the select?

SELECT SUM(valor) FROM contas where YEAR(data) = '2017' and MONTH(data) = '06'

mysql

asked by anonymous 06.06.2017 / 00:21

1 answer

GIT Change branch without committing or discarding current changes Doubt with JavaScript arrow function

score 3 · Accepted Answer

If possible, use the date_format() function by passing the desired format instead of the two functions. Y for the year with 4 digits and m for the month with two digits.

SELECT SUM(valor) FROM contas where date_format(data, '%Y-%m') = '2017-07'