How to rewrite this expression in the SQL query?

Tell me how to rewrite this line:
if($view_trip->date_trip.(" ").$view_trip->time_trip >= date("Y-m-d H:i") && $view_trip->view === "yes")
// in date_trip - date
// in time_trip - time

In such (subject to ordeb by id desc):
$sql = 'SELECT * FROM trips WHERE view = "yes" ORDER BY id DESC';
March 25th 20 at 12:38
1 answer
March 25th 20 at 12:40
Solution
SELECT * FROM trips 
WHERE UNIX_TIMESTAMP(CONCAT(date_trip, " ", time_trip)) >= UNIX_TIMESTAMP() 
 AND view = "yes" 
ORDER BY id DESC


Or something like that...
Why would you do this to UNIX_TIMESTAMP to overtake?
You can:
WHERE CONCAT(date_trip, " ", time_trip) >= NOW() - Cornell.Monahan commented on March 25th 20 at 12:43

Find more questions by tags SQLPHP