CODEWITHSUNDEEP
mysql
codeStruggler
codeStruggler

Reputation: 19

How to get records that are less than n minutes?

I am trying to get the records from php that every row have following table:

[created_at] => 2022-10-15 08:17:52

I want get record that are created last minute. for that i my php file:

SELECT * FROM customer_billing_details WHERE DATE_ADD(created_at, INTERVAL 1 MINUTE) >= NOW();

but it returning the same row even after it is more than 1 minute old, I dont able to understand what is happening.

Upvotes: 0

Views: 346

Answers (1)

Mash tan
Mash tan

Reputation: 159

You do not need >= NOW(). the interval will automatically handle the time interval. use something like

 SELECT *
FROM `customer_billing_details`
WHERE `created_at` >= CURRENT_TIMESTAMP - INTERVAL 5 MINUTE;

Change 5 minutes to 1 or 2 according to your needs.

Upvotes: 1

Related Questions