SQL statement based on $curr_time->format('Y-m-d H:i')

Question

Why this code...

$curr_time = new DateTime();
$query_inprocess = "UPDATE `MyTable` 
                    SET inprocess=1 
                    WHERE startTime <= '" .$curr_time->format('Y-m-d H:i') . "'";

...results in incorrect SQL query, in which the statement after < is ignored?

UPDATE `MyTable` SET inprocess=1 WHERE startTime <

Answer 1

Find the below one :

"UPDATE `MyTable` SET inprocess=1 WHERE startTime <= now()"

It may help you to get the exact result which one you need.