Remaining minutes between field and dateAtual

Question

I am trying to create a direct query in mysql where I must return some value if the time interval of the current date and my datareg field is 02 minutes.

SELECT * FROM tabelax WHERE grade = 19 AND NOW() <= DATE_SUB(datareg, INTERVAL 02 MINUTE)

I tried to use now() with date_sub my datareg field, but I think I’m floating.

I also tried with DATEDIFF , but is not returning

SELECT * FROM tabelax WHERE grade = 19 AND DATEDIFF(NOW(), datareg) < 2

Any suggestions ?

Answer 1

Try with this query

SELECT *
FROM tabelax
WHERE datareg > NOW() - INTERVAL 02 MINUTE

I await reply :)

Edit:

SELECT *
FROM tabelax
WHERE 
datareg >= NOW() - INTERVAL 02 MINUTE AND 
datareg <= NOW()

Answer 2

The DATEDIFF will not work for your case because, according to documentation, the result value is expressed in days, so it will not be possible to check the difference in minutes.

An alternative is to subtract the current date from the column datareg using the function TIMESTAMPDIFF which has a parameter for you to set the time unit (in the case MINUTE) and thus the result will be expressed in minutes:

SELECT *
  FROM tabelax
 WHERE TIMEDIFF(MINUTE, NOW(), datareg) <= 2;

---

TIMESTAMPDIFF

Returns datetime_expr2 − datetime_expr1, Where datetime_expr1 and datetime_expr2 are date or datetime Expressions.

In free translation:

Returns datetime_expr2 − datetime_expr1, where datetime_expr1 and datetime_expr2 are expressions of the kind date or datetime.