Why Am I Not Getting Results When Selecting Records Older Than 15 Minutes in MySQL?

Finding DateTime Records Older Than a Specific Time

In MySQL, selecting rows where a datetime column falls within a specified time range is a common task. However, when attempting to retrieve records older than a certain time interval, some users may encounter issues.

One such issue is described in a recent query, where a user attempted to pull records from a "creation_date" column that were older than 15 minutes using the query:

<code class="sql">WHERE creation_date >= DATE_SUB(NOW(), INTERVAL 15 MINUTE)</code>

Surprisingly, the query returned no results, despite the presence of records that met the specified time frame. Upon closer examination, it was identified that the condition used (">=") was incorrect. To retrieve records older than 15 minutes, the correct condition should be:

<code class="sql">WHERE creation_date < DATE_SUB(NOW(), INTERVAL 15 MINUTE)</code>

The "<" operator ensures that the "creation_date" value falls before the specified time range, allowing the retrieval of the desired records. With this adjustment, the query should now accurately return all records that are older than 15 minutes in the "creation_date" column.

The above is the detailed content of Why Am I Not Getting Results When Selecting Records Older Than 15 Minutes in MySQL?. For more information, please follow other related articles on the PHP Chinese website!