How to Calculate a Future Time in MySQL Using DATE_ADD()?

Calculating a Future Time in MySQL

To add a duration to the current time in a MySQL query, you can use the DATE_ADD() function. Here's how to do it:

The following statement:

SELECT * FROM courses WHERE (now() + 2 hours) > start_time

is invalid in MySQL. The correct syntax would be:

SELECT *
FROM courses
WHERE DATE_ADD(NOW(), INTERVAL 2 HOUR) > start_time

In this query, the DATE_ADD() function takes two arguments:

• NOW(): The current time.
• INTERVAL 2 HOUR: The duration to add (2 hours in this case).

The result of this function is a new time value that is 2 hours later than the current time. This value is then compared to the start_time field of the courses table to determine which courses have a start time within the next 2 hours.

For more information on date and time manipulation in MySQL, refer to the documentation on [Date and Time Functions](https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html).

The above is the detailed content of How to Calculate a Future Time in MySQL Using DATE_ADD()?. For more information, please follow other related articles on the PHP Chinese website!