Search time in mysql

Question

Colleagues,

I have a system that is storing the time of registration of users in the following format in the Mysql database:

11:11:00 ( the time may be any other as per the user’s registration )

But I created a Cron task where every minute I do a check in the database and run a task based on the user’s registration time. I used the following code for verification:

SELECT * FROM tabela WHERE DATE_FORMAT(Data, '%Y-%m-%d') = CURDATE() AND Hora =  TIME(CURRENT_TIMESTAMP);

The problem is that if the above code time passes the registration time, it does not perform the task. Ex.:

Registration time is 11:11:00 and the code time is 11:11:01, does not perform the task.

Answer 1

Try to use the TIME_FORMAT

SELECT * FROM tabela WHERE DATE_FORMAT(Data, '%Y-%m-%d') = CURDATE() AND TIME_FORMAT(Hora,'%h:%i') =  TIME_FORMAT(TIME(CURRENT_TIMESTAMP),'%h:%i');

https://www.techonthenet.com/mysql/functions/time_format.php