Filter query for mysql dates

Question

have this mysql table:

And I have the following appointment:

SELECT *
FROM tabela
WHERE 1 = 1
AND data_prova >= '2020-03-01'
AND data_prova <= '2020-03-26'

Well, with this select use for a filter and was to return me the last three lines, but it only returns me the day 02-03 and 24-06, the day 26-03 does not return, which error?

The field data_prova is the type datetime, and the date I’m putting as string.

Answer 1

You did not enter the time together with the time date. With this it assumes the standard "00:00:00.000" for the time.

Try:

SELECT *
FROM tabela
WHERE
 data_prova >= '2020-03-01 00:00:00.000'
AND data_prova <= '2020-03-26 23:59:59.999'